EPM Reporting format

[Former Member]

Hi,

I need to create a report with the following format as attached

.

I need to display the the children of the hierarchy node. Below which i need to display the user defined description of the node instead hierarchy node name. For the next hierarchy node members, there should be a blank line between them. Like this we have around 20 hierarchy nodes to be displayed.

How can I achieve it? Is it possible this using a single report or do I need to create individual report for each hierarchy node? What can be maximum number of reports in a work sheet for better performance.

* When i say report, its the Report000, Report001 etc and not the individual tabs in the workbook.

-- Selva.

[Former Member]

Selva

For a report with this layout:

I personally would select my entities member and descendants with totals after and include blank row for spacing. To get the label in the middle I would use a local member to display the name and hide the actual entitiy column. You could use a condition to test the entity and display the name for base members and lookup from some table for the user names or if the user name is available from a property use that. The formatting of the lines will probably need a formatting sheet. Nothing I see says it can't be done in a single report, so for performance start with just one.

~Ryan