Local Member description for actual calculation

[Former Member]

Dear Friends.

I have a nested report with CATEGORY, TIME, PRODUCT, ACCOUNT dimension in row and ENTITY in column. User need to create multiple local member toward the end of the row axis. The CATEGORY and TIME dimension will only have one member (e.g. ‘Actual’ and ‘2016.TOTAL’). PRODUCT & ACCOUNT will have multiple member.

In the attached screenshot when I create local member, it by default take the member in last row for PRODUCT dimension(highlighted in ‘Yellow’). But the user want that local formula should show the description of the formula. For example the row highlighted in ‘Green’ is calculation for TOTAL_PRODUCT and NET_INCOME – FXXX. Similarly the row highlighted in ‘Blue’ is calculation for CFO_TOTAL and PRE_TAX_INCOME – OTH_INC_EXP_NET.

How can I achieve this requirement from client.

Thanks,

Rahul

[Former Member]

Vadim, the report is dynamic and not static. If I use excel formula, then it won't work if the report expansion changes.

Thanks,

Rahul

[former_member186338]

Not clear!

In case of dynamic report EPMPOSITION(21) will be also incorrect 🙂

It's better to explain the real requirements for the local member!

[former_member186338]

Looks like you are creating local members automatically using local member recognition! And the formula is static with fixed positions.

In this case simply don't use local member 🙂 use Excel formulas on the report without local member recognition!

[former_member186338]

P.S. "CATEGORY and TIME dimension will only have one member" - then move CATEGORY and TIME to page axis!

[Former Member]

Hi Vadim,

Attached is the screenshot of the two local member setup!

Thanks,

Rahul

[former_member186338]

Please show screenshot of the local member setup!