cancel
Showing results for 
Search instead for 
Did you mean: 

How to have Variable popup in the Excel with HANA Connection

Former Member
0 Kudos

Hello,

I have a Calculation view with 3 input parameters. I wish to connect this calculation view using  Excel connection via MDX connection. But I dont see an option to get the variable popup to have in Excel. If I do data preview in Hana Studio, I see the input parameter pop up.

What is the best way to have a value passed based on the user input..

example: Selection is for date and I have to pass different value to get different set from the calculation view.

Appreciate the help..

Happy Tony

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Tony,

  At the present Excel is not supporting HANA variables/Input parameters.

Please refer the below link:Using SAP HANA Variables and Parameters in SAP BusinessObjects BI4.0

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a20445-6377-2f10-49ab-f6c9565db...

Thanks

Basha.

Former Member
0 Kudos

Hi,

Can we have now variable/parameter pop up in SAP Design Studio?.

Happy Tony

Former Member
0 Kudos

Yes Tony. Please refer the above link ,page no 52 explained  about variable/parameter pop up in SAP Design Studio.

Thanks

Basha.

Answers (1)

Answers (1)

former_member184969
Participant
0 Kudos

Hi Tony

The only solution I have found so far is to modify the HANA query, so that

1. The parameter is set to NOT mandatory

2 The parameter has a default value

... Then you can run your query in excel without any problem.

If anyone has a way/ semantic trick to fill in the parameter value in the ODBC connection properties , I'll be greatly interested.

Regards