cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 7.5 Modify Application > Add Shared Dimension to an existing Application

former_member244885
Participant
0 Kudos

Hi All,

I'm planning to add an existing Shared Dimension, from my dimension library, to an existing Application.

My understanding is that when I add this dimension to the already created cube, all the information of the cube will go to the first member of the new dimension.

(Ref: http://scn.sap.com/thread/1730717)

I'm going to need to change the member for all the preexisting data.  What's the best way to go back and edit this?

Finally, I'll need to go back to the existing reports and manually update the "page key range" to accommodate the new dimension.

Am I missing anything else?

Thanks,

Jon

Accepted Solutions (1)

Accepted Solutions (1)

former_member186498
Active Contributor
0 Kudos

Hi Jon,

I've never done that before but when you add a dimension the olap and the fact tables as I know were dropped.

  • First of all try in dev environment
  • do a backup of the fact table in a flat file
  • add the dim with at least a dimension member
  • add a column in the flat file containing the default value
  • load data into fact table
  • process dimension
  • process application to rebuild the Olap
  • modify script logic, stored procedures, packages, journal, security, etc that use this new dimension
  • modify all your templates (input sched and reports)

Regards

     Roberto

Answers (0)