Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need help writing EPM report

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

Tags:
Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question