Skip to Content

Error Processing Dimension / Dimension Formulas CL_RSR_MDX_CALC_MEMBER

Hi,

I am migrating a BPC 10.0 (CPMBPC 801 SP04) to BPC 10.1 on HANA SAP_BW 750 SP05

Steps so far:

- UJBR - Backup 10.0

- UJBR - Restore to HANA server

- Set Environment Online.

- RUN SE38 --> BPC_MIGRATE_TO_HANA

- (No issues up to this point)

- Take a simple Account Dimension Formula. Add " + 1" to the end of the line. Save

- Undo the change (above). (Now the Dimension Formulas are as they were).

- Process the Account Dimension.

- Error. (See below)

- If I delete all the Dimension Formulas and (manually) recreate them by hand, then the Dimension processes 100%. So there is nothing wrong / incompatible with the MDX. However, there are close to 200 of them, so to do this manually every time is not an option.
- I have also performed a SE38 --> Refresh Dimension Cache UJA_REFRESH_DIM_CACHE. No difference.

- I have got ENABLE_HANA_MDX on. (It does the same with it on or off)

- By-and-large, the majority of the Member Formulas are of the format A=[M1]+ [M2]+ [M3]. There is no fancy MDX code.

Any ideas?

Anyone experienced this before?

Ta

Nick

This is error I get:

MDX statement error: System error in program CL_RSR_MDX_CALC_MEMBER and form CL_RSR_MDX_CALC_MEMBER-01- 2017-01-30 11:13:45

End validating member formulas 2017-01-30 11:13:45

Start validating member formulas 2017-01-30 11:13:14

End validating the members hierarchy 2017-01-30 11:13:

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 30, 2017 at 01:56 PM

    May be only one formula generates this error?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30, 2017 at 08:42 PM

    Hi Vadim,

    As always, thanks for your speedy reply.

    I have looked at the Member Formulas and they seem OK, since I used copy/paste to replace all of them. I got the text from the Metadata.xml file from the UJBR backup. Notepad++ is my friend. (In fact, in QA we picked up a problem with bad syntax in 10.0 and fixed them there, before backing up).

    By "every time" I mean that we are going through a number of iterations (beginning with our QA system, but now on the production system) of backing up and restoring. There are some inconsistencies in the 10.0 system that allow it to work (in 10.0) but the minute we migrate, things break (legitimately). So we fix a few things, break a few and try again. So far, deleting all the Member Formulas is the only way we have been able to re-process the Account Dimension. Then I have added them back manually. Also the housekeeping has been a bit lacking so we are battling with some of that. Once we can import the entire 10.0 system cleanly, then, naturally, this should not be an issue.

    After deleting, I was hoping to upload the \ROOT\WEBFOLDERS\<Environment>\ADMINAPP\DIMENSION FORMULA\ACCOUNT.LGX file and somehow BPC would magically "restore" the member formulas, but I suspect they are also in a table structure and not just part of the file system. I tried refreshing the dimension cache, but that does not work. Perhaps there is another program I can use.

    Kind Regards

    Nick

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30, 2017 at 09:00 PM

    Thanks, Vadim ...

    Let me keep plugging away ... there must be a reason ... I'll keep you posted.

    BR

    Nick

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30, 2017 at 08:48 PM

    "I was hoping to upload the \ROOT\WEBFOLDERS\<Environment>\ADMINAPP\DIMENSION FORMULA\ACCOUNT.LGX file and somehow BPC would magically "restore" the member formulas," No :) You can debug UJBR code to look on formula processing...

    Add comment
    10|10000 characters needed characters exceeded