Import Memberformulas to Productive System

[ChristianSass]

Hi,

We would like to Import Member Formulas to Productive System and I get the following message:

##########

Invalid member formula existed in Dimension....

MDX Statement error: "MDX SYNTAX CHECK WITH #"

MEMBER ....".[PAREN'

Unkown message with SQL processing error: Error occurred while executi

##########

The formulas work perfectly in Dev., Prod. is locked so I cannot munually create the functions in Prod. System.

Thx for any hint on that

[former_member186338 · Accepted solution]

Please show the screenshot with some formula in dev that is generating error.

Vadim

[ChristianSass · Accepted solution]

Nothing special on the formula side

maybe I should add PAHRENTH1 .... everywhere but it works as designed on Dev-System

[former_member186338 · Accepted solution]

Let me see, what you have! PARENTH1 is not required. Also, please show you MEASURE formulas...

Vadim

[ChristianSass · Accepted solution]

Hi Vadim,

I've figured out something....

After I've turned off ENABLE_HANA_MDX I could create and activate the Formulas in Prod System -> there must be an issue with HANA

[ChristianSass · Accepted solution]

Haven't touched measure formulas at all ... should I?

[former_member186338 · Accepted solution]

Please show samples, without looking on you formulas I can't help!

[Former Member · Accepted solution]

When you have ENABLE HANA MDX = ON system checks completely different set of things than when that parameter is OFF. So, if you have it OFF in Dev but ON it Production then most probably it will fail during transport because you haven't checked those conditions.

[ChristianSass · Accepted solution]

Hi Gersh,

Dev. and Prod. are identical Systems and we test the formulas on dev. before transporting. I also checked all the Parameters in SPRO / BPC 3 times but we still have the described problems

Now, I've switched off MDX Support for the Moment but this is only temporary...

Thankful for any other hint

[Former Member · Accepted solution]

So, you are saying that you have ENABLE HANA MDX in Dev as well and there this member formula is working fine. Did I understand that right?

Can you try disabling, saving and then enabling ans saving again to check if it passes all tests?

If my understanding is correct, can you please check SLG1. usually message there is more elaborate that in SPRO Save.