How to prevent disabled Sites in CRM from showing in SSAS and SSRS

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

    Issue is that when supervisors & managers disable or delete Sites in CRM, I still get them displayed in SSRS (Reports drop-down parameters) and SSAS (cubes).

    How to I delete the disable or delete Sites (CRM) from showing in SSRS and SSAS ?

  • kevin_nikolai (8/19/2016)


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

    Issue is that when supervisors & managers disable or delete Sites in CRM, I still get them displayed in SSRS (Reports drop-down parameters) and SSAS (cubes).

    How to I delete the disable or delete Sites (CRM) from showing in SSRS and SSAS ?

    This is a SQL Server forum ... we do not know what your CRM solution is or how it works. If you ask a specific SQL Server question (eg, 'How do I modify SSRS run-time parameters?'), there is more chance that someone will help.

    Also, why are you posting questions about SSAS and SSRS in the SSIS forum?


  • Hi Phil, I used the section:

    Data Warehousing »

    Integration Services »

    How to prevent disabled Sites in CRM from showing in SSAS and SSRS

    So I was looking for a reply from people with knowledge of Data Warehousing & SQL Server Analysis Services (SSAS).

  • kevin_nikolai (8/25/2016)


    Hi Phil, I used the section:

    Data Warehousing »

    Integration Services »

    How to prevent disabled Sites in CRM from showing in SSAS and SSRS

    So I was looking for a reply from people with knowledge of Data Warehousing & SQL Server Analysis Services (SSAS).

    I am one of these people. But there is no concept of a CRM 'site' in either of these disciplines.


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

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