cancel
Showing results for 
Search instead for 
Did you mean: 

Selective Expansion of Nodes Requirement in Reports

Former Member
0 Kudos

I tried looking in the Delivered Templates and used the EVDRE function for my requirement but did not find the exact solution.

The users would like to manually select nodes in multiple line items, say Assets, Liabilities and Revenue in three line items. They would like to expand on Assets Node to the next level and so forth but retain Liabilites and Revenue at the Summary level itself.

I tried this using the DrillinPlace template and it works fine, but it only pulls the nodes in the order of the hierarchy (Assets, Liabilites and Equity and not Revenue). Can the users enplode on a given node to the next level and then click on one of the nodes in the result and get down to the base level members, while keeping the rest of the results still displaying.

Are there any sample reports available on EVEXP function.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I suggest evaluating the use of multiple EVDRE commands that share col ranges, but have their own independent Row memebrs for the drillprocess. That way, if a member is "clicked" only the active EVDRE will expand, either in place, keeping the rows, or as an expansion to the next level. I would avoid the EVEXP, since EVDRE should be able to outperform this function at all stages.

Hope this helps.

Former Member
0 Kudos

Using multiple EVDREs may not be the prettiest option but it sure does the trick for me. It definitely is a very good option and it works fine for my requirement. Thanks a lot for the tip.