P&L using BICS

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 :slight_smile:

Thanks a lot!


Bazyl (BOB member since 2014-03-18)

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 :us: (BOB member since 2012-07-30)

Measures hierarchy = hierarchy on mesures :]
Typical for P&L.

Like on the picture presented below - NTO, GTO, SPC are of course measures.
Przechwytywanie corr.jpg


Bazyl (BOB member since 2014-03-18)

so those are key figures? i haven’t seen this before and i doubt it is supported in bics/webi.


erik.stenson :us: (BOB member since 2012-07-30)

Yes, these are key figures. Any ideas how to present that in BO tools?


Bazyl (BOB member since 2014-03-18)

it won’t work like how you have in your screenshot


erik.stenson :us: (BOB member since 2012-07-30)

In Analysis for Olap it works great.


Bazyl (BOB member since 2014-03-18)