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

Question

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

kevin_nikolai

SSCarpal Tunnel

Points: 4343
More actions
August 19, 2016 at 5:17 am

#329232

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 ?

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

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

Phil Parkin SSC Guru Points: 246956 More actions · Answer 1

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?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

kevin_nikolai SSCarpal Tunnel Points: 4343 More actions · Answer 2

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).

Phil Parkin SSC Guru Points: 246956 More actions · Answer 3

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin