on 09-30-2010 4:57 PM
Hello everyone,
I have a universe created from a Bex Query which have a hierarchy in a characteristic like this:
Total (HIER_NODE)
Toalla
Pañitos
Papel
SBU_1 (HIER_NODE)
Toalla
Pañitos
SBU_2 (HIER_NODE)
Papel
As you can see there are some characteristic values repeated in different Nodes. When i execute a QAAWS or WEBI from this universe and show Level 0 and Level 1 from this characteristic the result is:
Col1 Col2
Total Toalla
Total Pañitos
Total Papel
SBU_1
SBU_2
The query does not show the duplicate values, ia hve research a little bit, and found that the MDX universe created is something like this,
SELECT
NON EMPTY HIERARCHIZE(UNION(.[LEVEL00].MEMBERS,[ZSD_MATNR__ZSD_CATEG ZCORP].[LEVEL01].MEMBERS)
DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS
FROM
I know there is a parameter in the MDX UNION(,,ALL) which "brings" the duplicate values, is there anyway to put this parameter in the universe, or create a new calculate measure which help me to obtain what i want:
Col1 Col2
Total Toalla
Total Pañitos
Total Papel
SBU_1 Toalla
SBU_1 Pañitos
SBU_2 Papel
Thanks
Edited by: cegarcia on Sep 30, 2010 5:57 PM
Hi,
This is a known limitation and you cannot modify the universe or create a calculated measure to solve this.
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.