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?