Skip to Content
avatar image
Former Member

BPC Script logic with HANA MDX

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 11, 2017 at 03:27 PM

    I do not recommend using mdx in script logic.

    Add comment
    10|10000 characters needed characters exceeded