cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate Values SAP BW Hierarchies

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

This is a known limitation and you cannot modify the universe or create a calculated measure to solve this.

Didier

Former Member
0 Kudos

Thanks Didier for your Answer,

do you know if there is a diiferent approach i can do to get a total value from the universe.

Thanks,

Answers (0)