Skip to Content
0

How can we parse input parameters in an MDX connection to Excel?

Dec 19, 2017 at 07:38 AM

34

avatar image

We use input parameters in some of our HANA Views. How can we parse these input parameters in an MDX connection to MS Excel?

mdx
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Maria Trinidad MARTINEZ GEA
Dec 19, 2017 at 08:06 AM
0

Hi Jeroen,

HANA CalculationVIews with mandatory Input parameters are not supported in Excel.

Excel has no concept of input parameters and thus we can’t query the user for the input parameter values.

This is documented in SAP support note 1723925 (S-user required).

A solution would be to modify the HANA views so that

1. The parameter is set to NOT mandatory

2 The parameter has a default value

Then you can point to your viewin excel without any problem.

Regards,
Trinidad.

Share
10 |10000 characters needed characters left characters exceeded