cancel
Showing results for 
Search instead for 
Did you mean: 

How to add dimension to a BPC model with Data without clean data

mrj_marcelo
Participant
0 Kudos
367

Hi, it is possible to add a dimension to a BPC model without clean data? If yes, there is any way to set a default value member to new dimension in model?

Accepted Solutions (1)

Accepted Solutions (1)

N1kh1l
Active Contributor

mrj.marcelo

There is no straightforward way of inserting a new dimension to the model and assigning it a default value. You can export all the data from the model in to a flat file, clean the model and then insert the dimension and load the file again with the new dimension pointing to a default value in transformation file or data file. I had done this once and the approach I took was above. I had to re adjust my templates but they did not give much issue. I ensured that data in my file was same as BPC cube. You can run optimisation with zero elimination to reduce the number of records. If possible take a backup of the model.

Br.

Nikhil

mrj_marcelo
Participant
0 Kudos

Thanks, perfect.

Answers (0)