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


Performance Point Server


Performance Point Server

Author
Message
ken-467489
ken-467489
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 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.
denglishbi
denglishbi
Right there with Babe
Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)Right there with Babe (765 reputation)

Group: General Forum Members
Points: 765 Visits: 1362
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search