cancel
Showing results for 
Search instead for 
Did you mean: 

Add new Dimension to Application with Data

sairam_kondaraj2
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

sairam_kondaraj2
Explorer
0 Kudos

Thank you Nilanjan!! I have more questions on this

Do we have SAP standard process for this?

Do we need to update existing script logic because of this Change?

Do we need to update existing reports because of this change except for any hardcoded cell references?

Thanks

Raj

Former Member
0 Kudos

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.