Forum Discussion
SAP BW BEx Value is not a cube
Community Championcan you share your M code for this query (you can get it from Advanced Editor in the Edit Queries Home tab
it could be multiple things, e.g.
1) you pass a text instead of reference to cube value
2) one of the values in the list is not valid and is causing an error (although it would have to be the first entry as you use List{0})
3) wrong syntax
anyway to determine what it is I need to see the code you are using
also have a read here
https://community.powerbi.com/t5/Desktop/Dynamic-Parameters-with-SAP-BW-BEX/m-p/623453
https://community.powerbi.com/t5/Desktop/SAP-BW-BEx-Dynamic-Parameters/m-p/464624
Stachu Thanks for the reply, here are my code screenshots:
This is the code as it comes ffrom BEx editor before manually making any changes
Here is the code creating the list that I am attempting to pass through the SAP parameter. Along with an image showing the formatting of the values before converting to a list:
Finally an image when I attempt to pass the list through the SAP parameter:
Thank you.
- Stachu
List{0} is giving a text - first value in the list, not the whole list
try this:
{Cube.ApplyParameter, "!V000011]",{List}}assuming I didn't made any typos copying syntax from your screenshot it should work - for the future it's much better to post as text rather than image
I tried your solution and unfortunately I am getting the same error. I was under the impression that I could use List{0} and it would return the entire set of weeks as they were converted to a list in the final step of my "List" query and appears as such:
I also tried your solution without converting my query to a list and still received the same error. With the query appearing as below:
Syndicate_AdminAdministrator
@Stachu Thanks for the reply, here are my code screenshots:
This is the code as it comes ffrom BEx editor before manually making any changes
Here is the code creating the list that I am attempting to pass through the SAP parameter. Along with an image showing the formatting of the values before converting to a list:
Finally an image when I attempt to pass the list through the SAP parameter:
Thank you.
