on 05-26-2010 3:18 AM
Hi,
We need to add a new Dimension to Application with Data in BPC 5.1 MS. What's the best way to do this and what are the steps involved.
I am thinking of the following steps to do this.
1) Take backup of Application and data using BPC Admin or take backup of fact table in the sql server
2) Add new dimension to the application
3) Write script logic to populate data with required value for the historical data
3) Validate and verify all reports and script logic ( Do we need to change anything here? )
Is this a massive task which affects existing Reports, Input Schedules, Packages and Script Logic?
Thank you
Raj
Hi Raj,
The steps which you have suggested will be fine. Alongwith it, take the back of audit data and work status also. After the addition of the dimension, you need to check each template an make sure that its working fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
As a process, I would suggest you to take the backup of your appset using server manager. Take an additional backup of the fact, fac2 and factwb table of your application from SQL. Similarly, take a backup of the audit data and the work status. The changes in the script or templates will be based on the need. You need test all these components and based on the requirement you have to make the changes. There is no thumbrule for the same.
Hope this helps.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.