= EPMLocalMember()

[Former Member]

Hi all,

I am trying to adjust an Input Schedule that lists the components of the budget in the columns with the various Accounts in the rows.

The components also have a corresponding "comments" column in addition to a final "Total" column which all utilise

= EPMLocalMember()

for example = EPMLocalMember("Total  Budget","003","000")

Does this mean that the figures are not stored in the underlying database? The "Total" column is effectively the parent of one of the dimensions- effectively seeming to roll up when the Input Schedule is refreshed but the total is not visible in the backend

Lucy

[former_member186338]

Hi Lucy,

= EPMLocalMember("Total  Budget","003","000") - is just a header of the local member. Please show the formula that was generated by local member. And please provide screenshot of the report!

Vadim

[former_member186338]

P.S. Like:

[Former Member]

sorry to appear thick... but you say generated?

Does this mean I was not typed in by the developer?  Because Member recognition is not selected in Options

[former_member186338]

Sorry Lucy,

You have to read at least help: EPMofc_10_user_en.pdf

16.4 Local Members

To understand how to create local members and how the final formula is generated.

Vadim

[Former Member]

Hi'ya Vadim

That was a great piece of advice!! I really get it now!!

One question though  In the local member tab there appears to be a strange addition to the formula.

Below for example is an attempt to sum the rows. what does it mean?

=SUM(R45C:R[-1]C)

[former_member186338]

Hi Lucy,

RC is Excel reference style (can be used instead of A1 style), please read Excel help!

But please provide screenshots. I don't know where do you see this formula!

Vadim

[jrg_finster3]

Hi Lucy,

its true, Local Member are not stored in the database. They are used to calculate some figures in a Report only. You can Change/configure the local members via Report Editor.

RollUp values (Totals, Parent Values etc.) are calculated by the OLAP engine and also not stored in the backend.

Regards

Jörg