How to prevent disabled Sites in CRM from showing in SSAS

  • I am running a data-warehouse which collects data from CRM.

    Issue is that when supervisors & managers disable or delete Companies / Sites in CRM, I still get them displayed in SSAS (cubes). How do I remove the disabled or deleted Companies / Sites (from CRM) from showing in SSAS cubes ? Do I remove the disabled or deleted Companies / Sites after loading Dimensions or apply it to Facts ?

  • You need to look at the process, or processes, that update/rebuild your dimensions and facts and resolve the issue there.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply