Issue with Member formula in BPC 10.1 after enabling HANA MDX parameter

[Former Member]

Dear Experts,

We are facing an issue with the member formula configuration in our project.

Currently, we have the ENABLE_HANA_MDX parameter enabled.

The formula doesn't fetch the required result when we pull data for single month using an adhoc report. However, when we pull data for multiple months we get the expected results.

After disabling the ENABLE_HANA_MDX parameter we are getting the required results for all cases (for single month or multiple months). But this parameter cannot be disabled as it is hitting the system performance badly.

Formula currently includes only the MDX supported functions such as sum, lag and lastperiods, so not sure if the issue is with the formula setup.

Thanks.

[damovand]

Hello,

Please clarify / confirm the following:

• What is your BPC, BW and HANA versions?
• Did this formula ever work before and if so when and what has changed?
• Does the formula work if you use ABAP OLAP BAPI, instead of HANA, to execute it?

Best Regards,

Leila Lappin

[former_member186338]

Sorry, but the member formula is still not provided - only function...

Is it: F_DSO_AL_NET_TEST ?

Second - use "Insert Image" instead of incorrect "Insert File"! I will not answer questions with "Insert File" - hard to read!

P.S. The required calculation logic is not clear! Have you developed the formula yourself?

[former_member186338]

It's really a strange idea to ask question about the issue with formula without providing formula itself and report sreenshots!

[Former Member]

Hi Vadim,

Below are the formula and report details:

LGF file for member formula: (for DSO_AL_NET)

*FUNCTION F_DSO_AL_NET_TEST
(60+(((SUM({[ACCOUNT].[102001C],[ACCOUNT].[102001Z],[ACCOUNT].[102010C],[ACCOUNT].[102003C],[ACCOUNT].[800120],[ACCOUNT].[102501C]},[PRODUCT].[PRODUCT_NONE])-
(SUM(LastPeriods(2,[TIME].CurrentMember),SUM({[ACCOUNT].[AG0197],[ACCOUNT].[800110]},[PRODUCT].[TOTAL_PRODUCT])-SUM({[ACCOUNT].[800001],[ACCOUNT].[AG00ICSALES]},[PRODUCT].[TOTAL_PRODUCT]))
))*30)/(([ACCOUNT].[AG0197],[TIME].CURRENTMEMBER.LAG(2),[PRODUCT].[TOTAL_PRODUCT])-(([ACCOUNT].[800001],[TIME].CURRENTMEMBER.LAG(2),[PRODUCT].[TOTAL_PRODUCT])+([ACCOUNT].[AG00ICSALES],[TIME].CURRENTMEMBER.LAG(2),[PRODUCT].[TOTAL_PRODUCT]))+([ACCOUNT].[800110],[TIME].CURRENTMEMBER.LAG(2),[PRODUCT].[TOTAL_PRODUCT]))))
*ENDFUNCTION

Report screenshots attached

Test1- when pulling only single month

test1.png

Test2- when pulling multiple months(including previous 2 months)

test2.png

Please note there is no change in source data in both the cases but the report displays different set of values for member formula for DSO_AL_NET based on months included in the report.

We are getting the expected results when pulling single month or multiple months when ENABLE HANA MDX parameter is disabled.