August 19, 2016 at 5:17 am
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 ?
August 19, 2016 at 5:45 am
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
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 25, 2016 at 1:48 pm
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).
August 25, 2016 at 2:04 pm
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
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply