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