LocalMember position

[Former Member]

Hi

In EPM10 I'm trying to create input template with combination of user key-in data, data expand from database & 30 formulas. To achieve this I created local member formulas with position, first formula created as local member with 'use excel cell reference' and 'insert at position' after column axis, second created one more local member formula by giving as 'insert after localmember (of first one)' like that  followed by 10 local member, after wards user key-in data columns, next again local member formulas with with 'use excel cell reference' and 'insert at position' after column axis. Please find below image.

But not sure, it is not taking position properly. If I refresh some times its work exactly, again refresh column positions are changing. If I insert one more column in middle then complete local member formula positions are changed.

How can resolve this issue.

In BPC 7.5 we have flexibility to insert in middle, to copy formulas across columns etc., but in EPM10 need to create manually each formula upto 10 cells.

In image Red color Rectangle box highlights - Formulas,

Blue color - user key-in data,

Green color - retrieve from database.

For all these cells in EPM10 need to create formatting also.

Regards

Madhu

[Former Member]

Hi

Is there anyone expert to reply for this discussion

Regards

Madhu