on 04-19-2013 3:43 PM
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
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
Thanks
Basha.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.