Need help writing EPM report

[Former Member]

Hi,

I need an Excel sheet with two reports (I think it should be two, maybe one would be sufficient).

The first (upper) report should show a dynamic list of accounts. The list is selected by property, so it can change as new accounts are added. The columns should show the selected entity from the context and a list of all intco dimension members which have a corresponding entity dimension member.

The second (lower) report should show a dynmic list of accounts different from the first report. The selection is also based on a property. The columns should show the intco dimension member for the currenty selected entity and for each column the entity member corresponding to the intco member shown in report 1 above.

The number of columns in both reports also needs to be dynmic as new entites and intco members are added.

Maybe this little mock-up can help.

I have no problem creating the first report. My problem is to define the column headers for the second report. Is there a way to make this dynamic?

Thanks,
Arnold

[Former Member · Accepted solution]

This was posted here by mistake, the correct thread is in the NW section.

[Shrikant_Jadhav]

Hi Arnold,

I think the solution provided by Vadim is the only way and it's working.

Shrikant