Forum Discussion
Anonymous
4 years agoNot applicable
Parameter in SAP BW Query Error
Hi,
I'm trying to pass a parameter to a SAP BW query but I keep getting an error that says "The value is not a cube." Below is my query. Much appreciated if someone can help fix this.
let
Prefix = "[0FISCPER]",
CuurentPeriod = Text.Combine({"Z6",Param_CurrentPeriod}),
#"GetParameterValue" = "[" & (CuurentPeriod) & "]",
Orders = #"Fact Sales Open Orders",
#"Added items" = Cube.Transform(Orders,
{
{Cube.ApplyParameter, "[!V000001]", {"[0FISCPER]." & #"GetParameterValue"}},
....
})
in
#"Added items"
- Anonymous4 years ago
I managed to get around the error by creating a fuction to pass the parameter 😃
4 Replies
- AlexisOlsonSuper User
Based on the sources below, the first thing I'd recommend is making sure Power BI is up to date.
- AnonymousNot applicable
I managed to get around the error by creating a fuction to pass the parameter 😃
- vkoppunuruFrequent Visitor
Can you share your solution.
It will be very helpful.
- vkoppunuruFrequent Visitor
This worked for me.
ST is current data in format YYYYMMDD