on 2023 Oct 18 8:04 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.