Skip to Content

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

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.


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?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 17, 2015 at 04:13 PM

    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)



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.