Webi drill filter on hirerchy should same as SAP Hierarcht structure.

[Former Member]

Hi Experts,

I want to know can we display the drill filter's value structure in the same as it is in SAP.

Ex

Country

-- State

------City

Currently I am getting the flate list of value, I want it to be like with hide and expand buttons. When I drop down the Drill Filter,

Thanks in Advance.

[vinay_lohakare5 · Accepted solution]

Hi Rachna,

Check my blog:

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2012/05/04/hierarchy-in-webi-as-d...

Hope it helps.

Thanks,

Vinay

[Henry_Banks · Accepted solution]

Nice use of Sections, Outline mode, and fold/unfold functionality.

This is a great approach for XI3.1 MDX universes.  still applies in BI4.0, although the BICS connection moves things forward (native hierachies / expand/collapse)

Regards,

H

[Henry_Banks]

Hi,

Do you mean Characteristic or Key Figure  Structures from BEX?

Yes, these Selection Structres  get flattened in WebI.    They are OK in Analysis-OLAP

Better to model the relationship between objects as a native hierarchy in RSH1 and consume it into webi.  the concept of  'structures' (native BW OLAP concept) doesn't integrate too well into BI/BO.

Regards,
H

p.s. other customers have raised enhancement requests about this here:

https://cw.sdn.sap.com/cw/ideas/6784

and https://cw.sdn.sap.com/cw/ideas/6782

please add your vote to these items.

[former_member189638]

It is not possible to get the expand button like hierarchy structure in WebI.

[Former Member]

Thanks for your reply Rakesh. I am not looking this Hierarchy structure in Drill filter drop down.