cancel
Showing results for 
Search instead for 
Did you mean: 

Select single hierarchy node and get always the values for the hierarchy node

Former Member
0 Kudos

We are on SAP BW 701, SP12 and use Xcelsius 4.0  (Xcelsius Enterprise 5.5.0.0; Build Nr. 12,5,0,1388).

Following problem:
In our queries (build with the query designer) we have variables on the hierarchy (Character: 0ORGUNIT). The hierarchy uses the temporal hierarchy join.

Now the user select a single hierarchy node; not the hierarchy node. We can see that only the single org-unit has been selected because you see the equal sign and not the "tree".

If we execute the query with the query designer the query and the results are fine.

If we use the same query in a Xcelsius dashboard we alway get the values for the hierarchy node and not for the selected single org-unit.

This the definitely a bug.

Does anyone has the same problem or may be a work around ?

Cheers

Holger

the attached file shows an example hierarchy and the red marked entry shows always the values from the hierarchy node.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

May be my description was a little bit unclear.

We don't show the hierarchy in the dashboard; we just use a hierarchy variable in the report of the query designer.

In the dashboard we only show the single result; in this case: the headcount; never the hierarchy.

As you can see in my newest attachment we try to "see" the value headcount "2" in the dashboard.

We select the single org-unit (from the query) but the dashboard always show the headcount = 50

Former Member
0 Kudos

Are you using hierarchy node variable? If yes than it will take into consideration all the nodes below it for calculation. That is why you are seeing the value 50.

I would suggest try using a characteristic variable on 0ORGUNIT. Pass the value in the Characteristic Variable and it should work.

Answers (5)

Answers (5)

Former Member
0 Kudos

Hello Bimal,

I've created a query with 0ORGUNIT in the filter. I put 2 variables to the character:

1) a character variable

2) a hierarchy variable (with temporal hierarchy join)

Now I select a single ORGUNIT (not a hierarchy node) on the character variable and a hierarchy node with the hierarchy variable.

When I excecute the query I only get the results for the hierarchy variable.  

Former Member
0 Kudos

I'm sorry but one problem isn't solved:

A user wants to select 1 oder 2 hierarchy nodes AND 1 single org-unit. I've integrated 2 variables on the character 0ORGUNIT (one hierarchy and one single variable).

If the user selects only the hierarchy node(s) or only the single org-units it works fine; but if the user selects both, the query result is always from the hierarchy node.

So isn't it possible to choose a hierarchy node AND a single character value ?

Thanks a lot for your help.

Holger

Former Member
0 Kudos

Hi Holger,

It is possible to select both. See example below:

Lets say your hierarchy is like this:

PARENT

A

     B

          C

D

     E

          F

A and D belong to Parent Node. Now if you select B in the hierarchy node variable and C in characteristic variable it will show both B and C, as C lies under B and B is already selected.

However if you select B in the hierarchy node variable and E in characteristic variable it will show output B with C inside it and E independently. Let me know if this is what you want

Former Member
0 Kudos

Hello all,

thanks Bimal, it really works..

But it must be possible to select hierarchy nodes and single org-units. So I've put 2 variables into the query; one for the hierarchy selection and one for single selection.

....not user-friendly but it works...

Thanks to all.

Former Member
0 Kudos

Hi,

It's not a bug ,the hierarchy structures in dashboards are designed based on the reports and the back-end level.

Even-though hierarchy is enabled ,you need to define the hierarchy structure in the xcel format and from their only you can display it as hierarchy.

If you are showing more than 2 level of drill down ,use x-tree add-on component make the hierarchy structure in Excel and continue so that you can expect the exact hierarchy structure that you are looking for.

Hope this Helps

Thanks & Regards

Vignesh VL

Former Member
0 Kudos

Hi Holger,

Just one question what component are you using for the Hierarchy Display?

Thanks,

Fazith