Skip to Content
avatar image
Former Member

CUSTOM MEASURE Not Working After Migration to SAP BPC 10.1 on HANA

Hello Experts,

We had a Custom Mesure to calculate Inception to date and it was working fine on BPC 10 on Oracle. Recently we migrated to BPC 10.1 Standard on BW 7.5 SP 6 on HANA. We have enabled the SPRO Parameters required for HANA as well as ENABLE_HANA_MDX successfully.The Custom Measure now fails with error MDX Statement Error:"Internal Error: no result set"

The MEASURE Formula is as below.

SUM([%TIME%].[2017_DUMM]:[%TIME%].CURRENTMEMBER,[MEASURES].[/CPMB/SDATA])

Surprisingly If I just change the formula to below, it works

SUM([%TIME%].[2017_DUMM]:[%TIME%].[2060_DUMM],[MEASURES].[/CPMB/SDATA])

2017_DUMM and 2060_DUMM are both base members. The problem is with CURRENTMEMBERS.

Kindly Help if you have faced something similar.

Regards

Nikhil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 22, 2017 at 09:24 AM

    Please show the screenshot of your TIME dimension administration. I suspect that it's configured incorrectly!

    All base members have to be in 3 level structure

    Add comment
    10|10000 characters needed characters exceeded