cancel
Showing results for 
Search instead for 
Did you mean: 

Webi with BW hierarhcy node level access?

Former Member
0 Kudos

Hi,

I am currently working in a BO/BW project (BO XI3.1 SP3, BW 7.01 SP6) where we are using a BW Profit Centre hierarchy in Webi.

The setup is BW cube, BW query, Universe and then Webi report.

The profit centre hierarchy node levels are displayed as L00, L01, L02 and so on up til L15.

The security concept should be based on BW profit centre hierarchy nodes at different node levels using BW roles.

A very simple report may look like a flat table with:

L03 PCH, L04PCH, Amount

For a full access user the report works fine.

But for a user with a specifc node level access to node e.g. L03 in BW, the webi report shows the correct total amount but the node levels are all shifted. In this case the report would actually show L06 and L07 content instead.

(L06 PCH), (L07PCH), Amount

The data seem to have an offset by 3 from the root node L00. (I guess this is because the webi contains the L03 as a first node)

Have anyone had the same experience and are there any way around it?

/Daniel

Accepted Solutions (1)

Accepted Solutions (1)

amrsalem1983
Active Contributor
0 Kudos

well, webi is not recommended for heavy hierarchy levels, try to use voyager or Advanced Analysis

but in your case, try to arrange the dimensions in the unverse to start with L00, L01,,, and so on.

good luck

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Daniel,

This is the default behavior of BO with integration of SAP.

The values in the levels never remain constant and shifts according to the user access.

There is a way which can be tried out in BO (depending on the requirement) with the use of variables. So, before suggesting you the solution, can you share more information on the requirement. What you exactly want to show on the report?

Eg. Which level you want to display in report? Is it always constant from user access level?

To which level you have the roles defined?

Regards,

Rohit

Former Member
0 Kudos

Hi Rohit,

Thanks for your reply!

The report requirement and design idea was to initially display L04 and L05 of the PC-hierarchy as this level gives a good overview of the overall costs.

We have also discussed more detailed reports where L06 and L07 are used.

The roles will be defined on the profit center hierarhcy. As of now some users should have full access, some users should have access based on node level L05 and some users based on L07. I dont have the full list of users though.

Obviously, based on your input (that the values never remain constant) I have to give the design a bit more thought as I think it will be confusing when the node levels are shifted depending on access.

But to simplify, if the access only is based on two scenarios:

1) root node (full access L00)

2) nodes on level 4 of the hierarhcy (L04)

and the report should look like

L04, L05, Amount

How can I use variables to avoid the shifting?

/Daniel

Former Member
0 Kudos

Hi Daniel,

some users should have access based on node level L05

Contradictory with the report lay-out. The user who have the access to Level 5 will never be able to see the Level 4.

Anyways, you can try creating the below variables for the simplified scenario as mentioned by you:

Assumption: There are two types of users Type 1 - Access to L0 and Type 2 - Access to L4. I am assuming Max level in

Hierarchy is 8. Also I am representing as L0, L1..L7 as object names.

 v Level 04 = If(IsNull(L07) and IsNull(L06) and IsNull(L05) and IsNull(L04)) Then L00 Else L04
v Level 05 =   If(IsNull(L07) and IsNull(L06) and IsNull(L05) and IsNull(L04)) Then L01 Else L05 

I hope you get the idea How to create the variables. So you can create the variables and check them. May be I missed in

defining the Levels in If condition. So just check that..

Regards,

Rohit

Former Member
0 Kudos

Hi Rohit,

Thanks for your reply.

The variables sovled that part of the problem but the performance was just not good enough so I had to switch back to standard BW webtemplates!