Hierarchies and formatting rules

You may also like...

25 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?

  10. vaman says:

    In my WEBi Query I want to print top 8 values from hierarchy which is coming from BEX and i want to print the level 2 hierarchy values and with out having the main hierarchy(0 &1).

    Can anybody help me on this.

    But whenever i apply ranking on Hierarchy I am getting the main Hierarchy level (0 & 1) values in the report.

    But i want with out Level 0& 1 i.e i need only level 2 values with out hierarchies in the report.

    I am using that hierarchy in Crosstab.

  11. Anil says:

    Hi Pieter,

    We have one scenario to achieve for Hierarchy(24 level deep) in Webi report built on Bex.
    Version BO4.1

    Profit Center Structure looks like this below:
    ENT30328 PARENT NODE
    ENT30395 CHILD LEVEL1
    ENT30044 CHILD LEVEL2
    ENT30004 CHILD LEVEL3
    ENT30389 CHILD LEVEL4
    ENT40500 CHILD LEVEL5
    Here User want to pull only the Profit Center ENT30004 CHILD LEVEL3
    But here it pulls the another level with it ENT30389 CHILD LEVEL4(Which is not required)
    How to restrict the hierarchy according to our requirement.Please advise

  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 *