SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

PerformancePoint wish list – change a datasource

One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid.  There is no way to do this.  Instead you must create a new datasource and build the Analytic Charts/Grids from scratch using the new datasource.  Why would someone want to change the datasource of an Analytic Chart/Grid?  Well, here is what happened to me recently: A bunch of Analytic Charts were using the same datasource, and I had a request to limit the “drill down to” for a certain half of the Analytic Charts to just a couple of dimensions, as opposed to the couple dozen dimensions being shown.  So, I created a perspective in the cube that limited the visible dimensions to those couple of dimensions.  But then the problem crept up: if I changed the datasource to use this new perspective, then all Analytic Charts that use this datassource would be changed to have just the couple of dimensions visible.  But I only wanted half the Analytic Charts to change.  So then I decided to create a new datasource that used the new perspective, then went to change half the Analytic Charts to use this new datasource.  But no luck – there is not a way to do that.

Note: Scorecards have the option to change the data source, but that ability was never given to Analytic Charts/Grids.

Bottom line: Use different data sources for groups of Analytic Charts/Grids if you think down the road you will want to use different perspectives for each group.

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


No comments.

Leave a Comment

Please register or log in to leave a comment.