Try to enable MDX_ON_HANA

[Former Member]

Hi,

We are on versions:

     BPC v10  with EPM 22

     CPBBPC 801 SP12

     NW 7.31 SP17

     HANA v97

We try to activate MDX_ON_HANA using  transaction code SPRO, and we have those errors:

     -     Invalid member formula existed in model "xxxxx"

     -     MDX statement error: "MDX SYNTAX CHECK WITH MEMBER [Account].[Parent.....

Anybody knows why we have those errors ??

I need EXPERT help !!!

thanks

[daniel_aporta · Accepted solution]

Hi,

we had the same problem. At least we removed all member formulas and still couldn't set the 'mdx on hana'-parameter. We found a program called 'UJHANA_REFRESH_VIR_CUBE'. After executing this program we could set the parameter.

Regards

Daniel

[Former Member · Accepted solution]

the ABAP  UJHANA_REFRESH_VIR_CUBE  fix our issue....thanks you very much !

[sreenivasulup]

Hi,

Is the issue occuring after any recent upgrade to HANA revision version? We have experienced the same recently post the HANA revision upgrade and the HANA mdx parameter could not be enabled back. Please look out for the relevant notes after confirming the same through a message with SAP support.

Thanks,

Sreeni

[Former Member]

When you enable that setting system checks formulas for all Dimensions included in that Model as well as all logic scripts associated with the Model. If you have member formulas in this Model that refer to other Dimensions then those Models with all their Dimensions will be included in that check as well.

If you are saying that none of the Dimensions in that Model has member formulas then please check all script logic files, especially if you have any MDX expressions there.

Regards.

[former_member186338]

Please provide member formulas in this model!

Vadim

[Former Member]

hi,

Member formulas are built on Dimensions and not Models, and I don't have any member formula on Dimensions used in this Model. That's why I don't understand why got those error. Is it a program error?   I didn't find any note.

Patrice

[former_member186338]

Provide formula samples, please! May be some syntax is incorrect for HANA MDX!

[Former Member]

We have 85 member formulas, do you know a BW table where I can extract them in one shot ?

[former_member186338]

Remove one by one to find the formula with issue!