on 07-05-2012 12:52 PM
Hi BEx fans
We need to design a report in BEx.
There is a hierarchy in play, with let us say 2 levels. 2 Key figures are determined.
Hierarchy Level 1 | Hierarchy Level 2 | Key figure 1 | Key figure 2 |
---|---|---|---|
Commercial Business | 150 | 150 | |
Mix0 | 100 | 50 | |
Mix1 | 50 | 100 | |
Non Commercial Business | 100 | 100 | |
Mix1 | 100 | 100 |
Regarding the key figures let us explain it more detailled, they are designed depending on hierachy level values:
Key figure 1 should be be restricted by Mix0 and Mix1 (hierarchy level 2). On the other way it should also be restricted on Mix1 (level 2).
I have defined a query which doubles the keyfigures, instead of 2 there are at all 4 keyfigures. Executing the query you will see the 4 keyfigures correctly in a line (row area).
If you add the charateristic with collapsed hierarchy you will also see the these key figures correctly, but if you extract the hierarchy level from 1 to 2, you will recognize that the doubled keyfigures will be shown (with no values -> correct).
Question: Do you know a way how to eliminate these "duplicate" key figure rows when using the hierarchy? Is there another way to solve this problem?
Thanks
T.
Hi Thomas
Is it possible to send a grid with the result and what you want to achieve?
Thank you
Yiannis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yiannis
Attached find an example.
Level 1 is "Business". Level 2 are "Commercial" and "Non Commercial".
Level 3 are the values as described above. These values are different for the keyfigures.
In the grid you can see that for "Commercial" KFG3 and KFG4 which belong to "Non-commercial" automatically are shown, correctly with 0.
The same for KFG1 and KFG2, shown under "Commercial" with values and under "Non-Commercials" without values.
Do you understand where the problem is?
Thanks Yiannis
Yes, you are right, the key figures are restricted by level 3.
Level 1 and Level 2 are text nodes and level 3 is "real" value of the characteristic:
Level 1 -> text
Level 2 -> text
Level 3 -> characteristic value
How can you restrict the keyfigure on level 2 if this is a text node?
Thanks
T.
If i am not wrong you can this is not a problem, hierarchy is based on a icharacteristic then restrict based on the hierarchy nodes.
The problem is that you can't use it twice in the report. If you do not want it for display then this is not a problem. If you want to keep it in the report then you have to create a new characteristic.
Thank you
Hi Yiannis
I have created a second charateristic which determines the logic of level 2 from the hierarchy characteristic (characteristic no. 1).
Then I additionally restricted the key figures with the relevant values of character no 2.
Unfortunately it doesn't work, still the same effect.
This is strange, as it is not really logic.
In the screen you can see KFG1 and KFG2, next column the new characteristic.
KFG1 is restricted additonally on value 1 of this new characteristic.
As you can see, the values 2, 3 and 4 are still displayed.
Do you know the reason for this?
Thanks
T.
There is a workaround:
Zero suppression (active values =0), apply to rows.
In workbook you can navigate to local query properties, and additionally are able to
-> apply also to members of structure key figures
-> apply also to members of structure struct.
This is only locally. Is there a chance to get these properties globally?
User | Count |
---|---|
88 | |
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.