Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / repopulate analysis cubes
Microsoft Dynamics GP (Archived)

repopulate analysis cubes

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

i have a scenario here. currently i have installed and configured the analysis cubes with TWO company. subsequently i created a new company called TEST. when i re-execute the analysis cubes wizard, to include TEST in the cubes, the TWO company's integration services get missing.

i tried it both way like click both TWO and TEST in analysis cubes wizard but end up either one will still be missing.

consequently, i remove all integration services packages, remove datawarehouse, and rerun the wizard with 2 companies selected, this time everything turns out fine.

however, we need to create and delete company from time to time. may i know what is the right steps i should followed when we have new company created in dynamics gp and need to repopulate the cubes?

 

thank you.

*This post is locked for comments

  • lerobles Profile Picture
    lerobles 5 on at
    RE: repopulate analysis cubes

    Hi all, do you know where can I find any Documentation or KB or something from Microsoft regarding this GP 2010 installer bug?

    I understand this is the bug number 8973....

    Please let me know.

    Thanks!

    Luis

  • Jason Wojtyna Profile Picture
    Jason Wojtyna 10 on at
    Re: repopulate analysis cubes

    Thank you so much David - that is very helpful!

    Jason

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: repopulate analysis cubes

    This is actually a bug with the GP 2010 installer.  The behavior changed from the old 10.0 version (at which point you would re-run the installer and simply add the new company).

    My "best practice" for adding a new company in light of this is as follows:

    - Add new records for the new company in LastUpdated table of the data warehouse.

    - Add new records for the new company in SystemVersion table of the data warehouse.

    - Copy an existing Master package into BIDs.  Change the Connection Manager string to point to the new GP database.  Change the gCompanyID variable to point to the new GP database.  Import the revised package into SQL and rename appropriately.

    - Add the new master package to the existing SQL Server Agent job.

    Other steps may be required, such as adding records to tables for multi-currency, etc. but this should at least get you pretty close.  In some ways, this might be easier than using the installer tool to rebuild the packages and possibly wipe out customizations you may have.

    David

  • Jason Wojtyna Profile Picture
    Jason Wojtyna 10 on at
    Re: repopulate analysis cubes

    I am having a very similar problem - we have several clients who have multiple GP companies, and we need some way of including newly added GP companies in an existing data warehouse without having to remove all GP SSIS objects, and then re-run the wizard.

    Are there any 'best practices' that are in wide use?

    Thanks!

    Jason

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans