Skip to Content
0
Jul 20, 2016 at 02:00 AM

Repetitive local members

217 Views

Hi Friends,

Env 10.1/7.4

I have a requirement to create a report which has lot of calculations. These calculations are kind of repetitive for every set of profit center nodes.

currently we have 4 top nodes of the profit centers

sample layout

Profit center node 1 (we will have 5 sets)

actual Plan

CY PY LM1 LM2 CY PY LM3 LM4

GL Account

LM - local member (calculation)

These 4 local members would repeat for 4 sets of profit center nodes and the parent node, In total I am having around 20 local members.

This report needs expansion on GL Account, so i have created local members based on position (as columns will not need any expansion)

like LM1= sum(epmposition(1),-epmposition(2)) ... etc and attached it the column axis at position(3) , 4 etc

this requires careful detailed work.

I was checking if there is an easier and elegant way to design a report.

Thanks for your time

Ed