Not triggering Member Formula

[nicky_hays]

Hi,

I have created a simple member formula and have processed it. It shows up as Green. But it is not getting triggered when I refresh or save data through EPM Excel Workbook. I have verified that the data exists for the 2 accounts shown below. Please help!!!

Regards,

Nicky

[damovand]

Hi Nicky,

I think what you are saying is that when you refresh a report you cannot see the correct value for the member with the dimension formula.  This sounds like an issue that should be investigated by BPC support. Are you checking the data through a report wihtin BPC or another client application using BPC data?

Regards,

Leila

[Former Member]

Hi Nicky

You haven't specified which version of BPC you are currently on, but this might be of help.

The following SAP Note might be relevant to you if you are on BPC on HANA.

2122679 - Member formula result member returns no data

If this note is not applicable to you, then possibly try using the fully qualified path for dimension member in your formula.

For Example: [ACCOUNT].[PARENTH1].[400000] + [ACCOUNT].[PARENTH1].[600010]

Hope this helps,

Kind Regards

Daniel

[former_member186338]

Hi Daniel,

"then possibly try using the fully qualified path" - useless proposal for ACCOUNT dimension.

Vadim

[former_member186338]

Hi Nicky,

What do you mean by "But it is not getting triggered"?

Please show a screenshot of the report with all 3 members: SEASONALITY, 400000,600010

Vadim

[Former Member]

Nicky,

Have you tried the UJA_REFRESH_DIM_CACHE program?

Jeff

[nicky_hays]

Hi Jeff,

tried that but still the same issue. I am able to save data from EPM Excel Worksheet but neither the Save nor the Refresh triggers the member formula.

Nicky

[former_member186338]

Formula is not "triggered" - it's calculated on the fly during report refresh! And only when you have the member with member formula on the report axis!

Vadim