Need help writing EPM report
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?
This was posted here by mistake, the correct thread is in the NW section.