on 07-23-2013 12:16 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Holger,
Just one question what component are you using for the Hierarchy Display?
Thanks,
Fazith
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.