Skip to Content

adding new columns to existing model from different source file

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

Add a comment
10|10000 characters needed characters exceeded

  • 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

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 29, 2020 at 12:09 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 29, 2020 at 12:30 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.