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

[mrj_marcelo]

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?

[N1kh1l · Accepted solution]

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 · Accepted solution]

Thanks, perfect.