Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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"

 

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    I managed to get around the error by creating a fuction to pass the parameter ğŸ˜ƒ

4 Replies