Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance Point Server Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 9:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 08, 2011 12:13 PM
Points: 5, Visits: 20
I need some help, I had to re-write an analysis services database (there was a failure I couldn't resolve without rebuilding) What has happened is some of the values changed within the database. After reconnecting the database and re-linking the values, some of them are still holding on to the old definition causing the reports to fail. Any ideas would be wonderful.
Post #892966
Posted Thursday, April 01, 2010 4:57 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:25 AM
Points: 347, Visits: 1,344
What items are currently causing you issues? Once you modify KPIs, Scorecards, Reports, and Data Sources and publish them to the repository these changes will take effect immediately on all items that are referencing them. If the errors you are seeing are related to filters on the links that are setup on the dashboard pages then you will need to redeploy the dashboard to the preview or SharePoint site to update the files.

If this does not resolve your issue then I would need more specifics. What type of error did you get in SSAS that you couldn't recover from? If you were doing this in project mode you should still have your files and just redeploy and process the database. If you are not doing project mode then you should definitely switch over and do so and get this checked into a source control system. You can open up BIDS and one of the Business Intelligence project templates will allow you to import an Analysis Service database. This option will create the project files from an existing SSAS database that is on a server (basically reverse engineering the database). In 2000 this was not an option, but starting with 2005 this was a new option and I would highly recommend it if you are not doing so currently.


----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Post #894593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse