on 09-03-2013 6:39 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.