Skip to Content
Former Member
Aug 30, 2017 at 10:25 AM

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:



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


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