system
1
Hi,
Do you have an idea how to create P&L (measures hierarchy) in Webi report based on BICS connection?
Also: if it could be easily done using another BO Tool, or let’s say Webi report based on Universe - that information would be also nice to know 
Thanks a lot!
Bazyl (BOB member since 2014-03-18)
system
2
I’m not sure what you mean by measures hierarchy - could you give some more information about your requirement?
with BICS the hierarchies need to be created on the BW/BEX side.
if you want native drill functionality (this is on dimensions) in webI then you need a universe, as that’s where those are defined.
erik.stenson
(BOB member since 2012-07-30)
system
3
Measures hierarchy = hierarchy on mesures :]
Typical for P&L.
Like on the picture presented below - NTO, GTO, SPC are of course measures.

Bazyl (BOB member since 2014-03-18)
system
4
so those are key figures? i haven’t seen this before and i doubt it is supported in bics/webi.
erik.stenson
(BOB member since 2012-07-30)
system
5
Yes, these are key figures. Any ideas how to present that in BO tools?
Bazyl (BOB member since 2014-03-18)
system
6
it won’t work like how you have in your screenshot
erik.stenson
(BOB member since 2012-07-30)
system
7
In Analysis for Olap it works great.
Bazyl (BOB member since 2014-03-18)