Forum Discussion
Error: The value is not a cube
Hi PowerBWhy
"From that filtered table I am creating a custom text column to match the format of how the date appears in the sap parameter. I am then taking that custom column and adding it as a new query titled "List." "
Could you show me what you create or the code in Advanced editor?
Do you create parameter on SAP side or on Power BI side?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft Thanks for your reply. I am creating the parameter in SAP BEx editor by selecting a set of dates then attempting to edit that code with a query that is a dynamic set of weeks formatted as a list. Sorry if that didn't answer your question as this is something that is fairly new to me. I will detail my code below.
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.