Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SAP BW Cube Parameter not applying

Hello,    We are just starting to use the SAP BW Connector and having some issues with applies parameters not filtering results.    We are using the SAP BW 2.0 connector.    We first noticed a ...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi dice927, 

You said that this don't work in powerbi, if you refresh the data preview wondows when you click "apply", will this work? In addition, if you re-open the desltop and re-connect this database,  will this work? By the way, what is your current version of desktop? You could try to copy the successful M code from Excel in PowerBI to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pressing Apply in the query preview does not seems to apply the variable being selected.

 

I am on the Novemeber Release of Power BI

 

I am not using Power Query in Power BI, it is a third party plug in called Analyzer the connects directly to BW not using M Code, so there is no M Code to copy over. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi All,

     

    Has this issue been resolved by anyone ?

     

    I am experiencing the exact same results - the Cube.ApplyParameter function does not apply on some of our Bex Queries but does work OK on others.

     

    Could it be a setting in Bex Designer that needs to be applied ? 

     

    I am on Version: 2.79.5768.1082 64-bit (March 2020)

     

    Thanks,

    Vladimir

     

     

    • vkoppunuru's avatar
      vkoppunuru
      Frequent Visitor
      3 years ago

      this worked for me.

      build data to pass to variable first.

       

      Y = 2022
      M = 09

      D =01

      STD = "["&Y&M&D&"]",

      [20220901]


      EDT = "["&Y&M&D&"]",

      [20220901]


      {Cube.ApplyParameter, "[!V000001]",{"[2CHL05K5655I2P086O3I7LPCUPH]."& #"STD"}},
      {Cube.ApplyParameter,"[!V000002]",{"[2CKV58XX4OIRD795WKZ19FB7KOE]."& #"EDT"}},

      • QC's avatar
        QC
        Icon for Kudo Kingpin rankKudo Kingpin
        3 years ago

        You are awesome! Just encountered the same issue and this totally worked, thank you!