SAP OLAP Universe

[Former Member]

Hello experts,

I've generated a SAP OLAP Universe and now I want to create a new group for a dimension for my universe.

Situation actual :

L0 Product Revenu

A 50

B 10

C 70

D 40

Future situation :

Group product Revenu

Group I 70

Group II 110

NB : Group I is product A and B

Group II is product C and D

To resolve this I create two new objects in my universe

Object name: Group I

Select

@Select(Season\L01 Product)">

Where

<FILTER KEY="@Select(Season\L01 Product)">

<CONDITION OPERATORCONDITION="InList">

<CONSTANT CAPTION="A "/><CONSTANTCAPTION="B"/>

</CONDITION></FILTER>

Object name: Group II

Select

@Select(Season\L01 Product)">

Where

<FILTER KEY="@Select(Season\L01 Product)">

<CONDITION OPERATORCONDITION="InList">

<CONSTANT CAPTION="C "/><CONSTANTCAPTION="D"/>

</CONDITION></FILTER>

With they objects group I and II , I have good values for product but when I create query with objects : Group I and measure Revenu .I have no data in my report?

Do you have in solution for this problem or any suggestion for resolved this situation in Designer or With variables in Web intelligence.

Thank you and happy new years 2011

[arijit_das · Accepted solution]

In WebI, you can create a variable as below:

v_Group =If([L0 Product] InList("A";"B");"Group I";"Group II")

Then cretae a Vertical Table with columns v_Group and Revenue.