Skip to Content
0

BPC Script logic with HANA MDX

Aug 11, 2017 at 01:42 PM

95

avatar image
Former Member

Hi,

We are trying to use statement like below in BPC script logic with HANA MDX -

[ACCOUNT].[#ACT200] = ([ACCOUNT].[ACT500],[AUDITTRAIL].[ECC],[INTERCO].[TOTAL_INTERCO],[TIME].CURRENTMEMBER.LAG(1))

We have noticed keywords CURRENTMEMBER and LAG causing the issue. This statement is works fine when we disable HANA MDX parameter in SPRO. With HANA MDX enabled this statement gives error like this -

UJO_READ:MDX statement error:"Internal error : no result set"

Can you please let us know if we have any issues with given keywords?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Aug 11, 2017 at 03:27 PM
0

I do not recommend using mdx in script logic.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks. Can you pls let me know if there is any alternative way of above statement .

0

First - please change your name to real, you are violating forum rules.

Second - explain in details business logic you want to achieve. It's meaningless to talk about single statement.

0