Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

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.


No comments.

Leave a Comment

Please register or log in to leave a comment.