BPC Report non-local member having formulas.

[former_member731436]

I have a report where the column that are real dimension (not local member) is having a formula (e.g. EPMRETRIEVEDATA(). Can I know where is the setting for it? (I cannot find it in the local member setting because it is not a local member, it is just a dimension)

PS: cannot "Insert Image", hence "Insert File" in below reply:

in the below blue columns are dimensions, orange are local member.

the column G is only having values (e.g. 196000), but column H is having = EPMRETRIEVEDATA(???). how can it be?

[former_member186338 · Accepted solution]

Formula in data cell can be configured in formatting sheet as content replacement.

Another option - EPMCopyRange

P.S. Please, never use "Insert File" instead of correct "Insert Image" for screenshots.

[former_member731436 · Accepted solution]

Thank you @vadim.kalinin

You are absolutely correct!

[former_member731436]

attached image