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
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
    4 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!