Skip to Content
avatar image
Former Member

Drilldown to Base Member

One of my users has requested an eExcel report that will drilldown to the base members rather than the next level when they double click on a row. In the example below, if Parent is doubleclicked, the user would like to see A,B,C,D,E instead of Child1,Child2,Child3. Is there any way to do this? I realize that I can set up the report to show the parent and the base members, but the user is requesting a collapsed report at the parent level that allows them to drilldown on the parent(s) they wish. Any ideas???

Parent
    Child1
      A
      B
    Child2
      C
      D
    Child3
      E

Thanks!

~Alison

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 17, 2008 at 06:09 PM

    Hi,

    If EVBSS and EVBAS are not helpful, then you can create a new hierarcy and use it in the report. Or you can have a new property and filter the report based on the property. Or Hlevel property can be tried.

    regards,

    Lokesh Nandula

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 07:59 PM

    If you are using an EVDRE process, you may test the ability to utilize the LDEP(#) feature, where the drill will be down a number of dependent levels below the selection. Just try LDEP(2) in the Member selector of the dimension in the EVDRE.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 12:06 PM

    Thank you for your suggestions. I am using EVDRE. Currently, in MemberSet I have ALL,ParentAfter AND Rpt_ID=4, SELF in order to get the appropriate parent levels to display (Rpt_ID is a property). Where would LDEP fit into this formula? I've tried a couple of locations unsuccessfully.

    My understanding of LDEP was that it would impact the report at time of expansion- not that it would impact the drilldown feature. Petar, can you please clarify that for me?

    Add comment
    10|10000 characters needed characters exceeded