cancel
Showing results for 
Search instead for 
Did you mean: 

Getting the individual levels of hierarchy and the key in universe

former_member212706
Participant
0 Kudos

Dear Experts,

     We have a reuirement where we need to create a universe on top of a Bex Query(which has hierarchy on 0Costcenter) using Universe design tool. When we try creating a universe the class costcenter shows all Hierarchy levels L00-Lxx. Along with this we like to have the key of last level in each record.

For example.

If i create a universe and use it in webi report, i get some records like this

L00     L01     L02     L03     L04   

A        AA     AAA     01

A        AA     02

A        AA     AAA     AAAA     03

In the report we would like to have another column showing the individula PCC

L00     L01     L02     L03     L04        PCC

A        AA     AAA     01                   01

A        AA     021                              02

A        AA     AAA     AAAA     03      03

We couldnt achieve this at webi level. Is this possible to get the PCC value using universe?

Version details: SAP BO 4.0 SP5

SAP BW 7.0

Thanks in advance !!!

Regards,

Rajesh.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Select the Properties tab. Notice that the check box Associate A List Of Values is enabled. By default, this check box is enabled on all dimension and detail objects

Regards

NK