Skip to Content
avatar image
Former Member

How can I drill down on a report more than one level?

We have what seems to be a sporadic issue - in an EVDRE if we have parents, we can drill down 1 level, however, when we try to drill down on the next level, only the formula for that cell appears. Does anyone have an idea how to fix this so a user can drill down to the base level??

Thanks,

Teri

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 04, 2008 at 07:43 PM

    Hi Teri,

    Please note that the level to which you are drilling down is sensitive to the settings of the memberset for that dimension. If its set to "self" your drill down path will be limited. Try entering ''self,dep", select the highest parent for that dimension, expand and now drill down. You should be able to reach the base level.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 07:11 AM

    Hi,

    you can indeed select the highest parent in the selection and choose self,dep as expansion

    or you can work with ldep(5) for example in the expansion (this means it goes 5 levels deep)

    --> you can add a combo box and choose how much level you want to go deep. Using a VLOOKUP function, depending on what you whoose in the combo box your expansion changes

    Best regards,

    Benjamin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2009 at 09:32 PM

    We were looking for how to easily switch from drilling down to the next level than to the base level, like in Essbase, but it doesn't seem like that is possible.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2009 at 09:33 PM

    We were looking for how to easily switch from drilling down to the next level than to the base level, like in Essbase, but it doesn't seem like that is possible.

    Add comment
    10|10000 characters needed characters exceeded