Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 14, 2015 at 04:04 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2015 at 10:48 PM

    Hi Arnold,

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

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded