adding new columns to existing model from different source file

[former_member692525]

Hello All,

I am facing one issue with adding new columns from different source file ( excel) to existing model ( BW acquired Conection). I have one model created based on a import connection and now I want to add new columns to this model which will be coming from a excel file. This excel file has a common dimension which i want to use as a joining or linking dimension. when import this new file to the model and open the file to map , the measure is shown as dimension and no there is way to change it to measure.

If you have faced this and know how to resolve this issue , would really appreciate your help. Thank you in advance

Regards,

Anita

[former_member692525]

Sample model dimension and measures:

Existing model had :

Dimension : Materialnum ( value - 1000) , Month ( value - 01) and measure - Quantity ( 500)

Now with new import file i have new columns:

Dimension : Client ( abc), Materialnum (1000). and Measure - Share ( 50)

Expect to join on the materialnum column the model should have now

Materialnum Month Client Quantity Share

1000 01 abc 500 50

[former_member692525]

Hello William, thank you for your reply. I will try this option

[former_member650982]

Hi adding new dimensions is a pain - rebuilding a model is a pain. Next time you rebuild the model - it’s brought back to its initial state and things gets reset and deleted

I would recommend building a new model - you will never get to a state where you are satisfied

Models are kind of set in stone once built

And sap has nothing on the roadmap for models - only datasets - but in the current form in Q3 2010 release - it’s still not workable. Let’s hope for Q4 2020 or Q1 2021. But for models...

Go in and vote on this IR

https://influence.sap.com/sap/ino/#/idea/229660

We are on 94 now - and we need more. A lot more in order to convince SAP that we need to rebuild models. Vote vote vote.