Skip to Content
avatar image
Former Member

BPC MDX syntax Logic Script Calculations all zeros result issue on HANA

Hey Guys,

Thank you very much for your help so far.

I came across next problem I need help with, hope you can provide me some info.

After SAP BPC database upgrade from Sybase to HANA I have received issue form user (let’s call him Mark) that MDX logic script calculations he performs end with success status, but the results are all zeros.

So I logged on to SAP BPC and perform those calculations. They results I got were not all zeros and were correct.

I checked Mark user access rights- he had:

/POA/BUI_FLEX_CLIENT and

/POA/BUI_UM_USER.

Then I gave SAP ALL rights to Mark. He reported back that after receiving this rights those calculations gave him correct results.

The situation is summarised in this table.

DB Technology / User Rights /POA/BUI_FLEX_CLIENT

/POA/BUI_UM_USER.

SAP ALL Sybase MDX Calculations: Proper results MDX Calculations: Proper results HANA MDX Calculations: All zeros MDX Calculations: Proper results

After this check I had to take back SAP ALL rights from Mark. The temporary solution I have found is to change MDX syntax to Allocation syntax.

Have you got any idea how to run MDX Logic Script Calculations on HANA with limited user rights and get proper results?

Let me know if you need the scripts I mentioned above. I don’t post them now, because they are long and I want to keep my post clean.

Have a great day!

Piotr Stepnowski

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 30, 2017 at 10:38 AM

    Start with some simple script to reproduce the issue!

    Use UJKT to test it and provide the log under Mark user and under SAP ALL user

    Without logs - nothing to discuss.

    Add comment
    10|10000 characters needed characters exceeded