Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Edit Variables as Slicer or dropdown for the user

Hi,   I am using HANA view as a data source for my Direct Query Power BI Desktop Report. HANA View works on mandatory variables that need to be passed such as 'UNIT' in which the data will be calc...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    You have created a parameter named Unit, and define some values for it , right? If so, change {Cube.ApplyParameter,"UNIT",{'"&Unit&"'}} to the following:

    {Cube.ApplyParameter,"UNIT",{""&Unit&""}}

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Lydia,

 

Thankyou for your response :)

 

Since my dataset is huge i can't use import mode, i am using Direct Query Mode.

In direct query mode edit parameters option (Create Parameters) is disabled.

 

Although let me try using import mode if passing values to HANA variables is possible through parameters.

When i use import mode , we need to pass values to HANA View Variables to import Data.Therefore it generates the Mquery according to that.

 

Unit , Time_Frame and Material are HANA View Variables . Fro example 'kboe' is a value i passed to Unit variable to import data.I want to create a parameter for it , so i used :

{Cube.ApplyParameter,"UNIT",{'"&Unit&"'}}

where Unit is a Parameter.

It also does not seem to work for me.It does not do anything.

Please suggest

 

 

Regards

Kanika Jain

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

You have created a parameter named Unit, and define some values for it , right? If so, change {Cube.ApplyParameter,"UNIT",{'"&Unit&"'}} to the following:

{Cube.ApplyParameter,"UNIT",{""&Unit&""}}

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks a lot Lydia.

     

    This solution worked for me :).

     

    One of my Parameter is of type integer.

     

    I am using the following syntax for passing parameter Year_Start

    {Cube.ApplyParameter,"Year_Start",{"&Year_Start&"}},

     

    This statement throws the following error below :

     

    Can you please suggest

     

    Regards

    Power BI User

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous，

      Please check my second reply in this thread. Create the Year_Start parameter in Text type, then use Number. FromText() function.

      Regards,
      Lydia