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

[William_Yu · Accepted solution]

Once the model is created, you are not able to add new column(dimension) into the model when import data from file. What you can do is, first add this new dimension into model through modeler and then load data from file into this updated model.

[former_member692525 · Accepted solution]

Hi William, I added the rebuild the model and added the blank columns for the columns I want to add. However when i add new import file only with these new columns and map it with the newly created columns, I still get error that the rest of dimensions are not mapped. So I tried to set the default value either value or '#', is this correct approach?

[William_Yu · Accepted solution]

Hi Antia,

Of course you need either map a dimension with a column from file or assign a default value, that's the right approach.

Best regards, William

[former_member692525 · Accepted solution]

hi William, i added the new dimensions / measures to actual model but does the load file should have data for all columns or can just be for the new columns?

[William_Yu · Accepted solution]

Uploading data to model is always for all dimensions and measures.

[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.