Forum Discussion
PowerQuery Essbase connector (how to get item code)
I would like to deliver an SKU_code in the step called Added Items, but i Only deliver SKU_Names.
All the Levels of the PowerQI retrieval Levels 1-6 are containing only description, but i cannot retrive technical code.
How to deal with it?
Help me, please.
RU3PNL.RU3PNL = RU3PNL{[Name="RU3PNL.RU3PNL"]}[Data],
#"Added Items" = Cube.Transform(RU3PNL.RU3PNL,
{
{Cube.AddAndExpandDimensionColumn, "[PRODUCTS]", {"[PRODUCTS].Levels(6)"}, {"Finished Goods Products.Finished Goods Products.Level 6"}}
})
in
#"Added Items"
4 Replies
You are going to have to provide more information Anonymous - unless someone has Essbase and the same table you are working with, it is going to be very difficult to understand and resolve the issue.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.Well, imagine all i have is a Table called Products and it has 6 levels of granularity.
From brands to SKU. The problem is, that i somehow only able to retrieve a description of any level, i.e. at the level of SKU: Product1 instead of P_100500 <- technical code of it. I bet there is any way to construct my query to deliver this. That is it.
You can ask us to imagine, or you can provide data. 😁
