Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 19, 2017 at 08:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded