Forum Discussion
sap bw conncector
Hi,
It's the first time i use this connector. Everythig was right, but in the preview data when and select the field "material" display the description and, obviusly i need the code to use the master data of the model.
What should I do to change this?
Thanks for your help.
Best regards.
Miguel
10 Replies
Hi MIGUELG,
Could you please elaborate more details about your requirement ? Where do you want to apply the code in Power BI Desktop? We will appreciate it if you can post a screenshot.
In addition, please check this blog to get details about how to retrieve and handle SAP BW data from Power BI Desktop. Also please note that Hierarchies and variables/parameters are currently not supported in this Preview version of the SAP BW Connector, but will be supported in the future.
Thanks,
Lydia ZhangHi Lydia,
I need the material code, and others codes (customer, sales representative...) in order to join the sales table characteristics with the master data.
Altough the object "Zmaterial" is defined to display only "code" when i made the extraction in the table display the description.
Obviously this is a problem to data consistency in the model.
I checked the code of the extraction, and i don´t know is modifying something thre it will be able to solve the question.
let
Source = SapBusinessWarehouse.Cubes("172.31.100.217", "00", "500"),
ZSD_C2016 = Source{[Name="ZSD_C2016"]}[Data],
#"ZSD_C2016/PBIX_VENTAS_2016" = ZSD_C2016{[Id="ZSD_C2016/PBIX_VENTAS_2016"]}[Data],
#"Added Items" = Cube.Transform(#"ZSD_C2016/PBIX_VENTAS_2016", {{Cube.AddAndExpandDimensionColumn, "[ZMATERIAL]", {"[ZMATERIAL].[LEVEL01]"}, {"material.material Nivel 01"}}, {Cube.AddMeasureColumn, "VM Kilos/litro estad", "[Measures].[00O2TNWJBJ8BO9TTN70WXTOAH]"}})
in
#"Added Items"Thank you for your help.
Best regards.
Miguel
- DavidMoss
Advocate V
I just posted a work around using SAP APD to this here
