Hierarchies and formatting rules

You may also like...

23 Responses

  1. Shaun says:

    Excellent tip – thanks!

  2. erdem says:

    how can this fold unfold menu in webi. i tried but i couldnt find like this.
    ( i mean machines(+),vehicles(+))

    i coulndt do this..

    could you explain.?

  3. erdem says:

    thank you.. i will try

  4. erdem says:

    bo 4.0

    i have a hierarchy.

    bu i cant do (+) and (-) fold unfold menu..where is it?

  5. erdem says:

    i cant still..please help

    • Hi Erdem,

      Did you enable the hierarchy option on the InfoObject in the BEx query? Please send me an email (contact page on this blog) if you need more information.

      Regards,
      Pieter

  6. femi says:

    I Pieter. Thanks for this post. Very useful.
    I got a question for you though. Can this .depth function be used to hide a level in the hierarchy? for instance, using your data in the example above, could it be used to hide the level that has Special Pump and just list Pump PRECISION 100, etc under Pumps instead. The issue I’m having is that I don’t want to drill to every level in the hierarchy to get to a lower level.

    Thanks

  7. David says:

    I think the [+] sign is a BEx query speciality. You wont get that (much as we all might want it) from an SQL query.

  8. David says:

    I have found a posting by Dave Rathburn that shows a way of doing this kind of conditional formatting when using regular report drilling

    http://www.dagira.com/2012/03/30/drilling-to-details/

  9. Hieu says:

    If i don’t use an olap, can I use the sign (+) and (-) in report to drill down and up?

  1. January 23, 2012

    RT @XcelsiusGurus: "New Post via @pverstraeten: Hierarchies and formatting rules: http://t.co/twz58nft #WebI #BOBJ #BI4”

  2. January 23, 2012

    RT @XcelsiusGurus: "New Post via @pverstraeten: Hierarchies and formatting rules: http://t.co/fES9vhpH #WebI #BOBJ #BI4”

  3. January 23, 2012

    New Post via @pverstraeten: Hierarchies and formatting rules: http://t.co/xr8dufyD #WebI #BOBJ #BI4

  4. January 23, 2012

    New Post via @pverstraeten: Hierarchies and formatting rules: http://t.co/xr8dufyD #WebI #BOBJ #BI4

  5. January 24, 2012

    SAP BO BI 4.0 Webi hierarchies and formatting rules http://t.co/oVTOwBQs

  6. January 24, 2012

    RT @XcelsiusGurus: "New Post via @pverstraeten: Hierarchies and formatting rules: http://t.co/fES9vhpH #WebI #BOBJ #BI4”

  7. January 24, 2012

    New blogpost on http://www.pieterverstraeten .com: Hierarchies and formatting rules http://t.co/a1M96BQj #BI4 #webi #SAP #BusinessObjects

  8. January 24, 2012

    RT @pverstraeten New blogpost on http://www.pieterverstraeten .com: Hierarchies and formatting rules by @raoullabega http://t.co/echa6YpX #BI4

  9. January 24, 2012

    New blogpost on http://www.pieterverstraeten .com: Hierarchies and formatting rules http://t.co/a1M96BQj #BI4 #webi #SAP #BusinessObjects

  10. January 24, 2012

    New Post via @pverstraeten: Hierarchies and formatting rules: http://t.co/Leej5sjd #WebI #BOBJ #BI4

Leave a Reply

Your email address will not be published. Required fields are marked *