cancel
Showing results for 
Search instead for 
Did you mean: 

New object at universe designer

Former Member
0 Kudos

Hello Gurus,

1.Can we Create a new Object at Universe designer on top SAP BW.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi ,

Yes you can create measure objects using XML .

Here are the steps :

To create a calculated measure in an OLAP universe:

1. In Designer, open an OLAP universe.

2. Insert a new measure object in the universe.

3. In the Where: box, enter or paste the object definition as an XML/MDX

expression.

4. Click Parse to review the object definition and fix any errors.

5. Click OK to save the object definition.

6. Select Tools > Check Integrity.

Former Member
0 Kudos

Thanks for the reply Imran. I am not aware of XML..

The reason behind in creating a new object at universe level is i want to calculate the Prior YTD amount in my webi report. How can i achieve this? At universe level/report level we donu2019t have any field for prior YTD in BEX query

If at report level steps please or else universe level steps please.

Really appreciate your help

Thanks.

Former Member
0 Kudos

Hi ,

Here is the MDX syntax for creating a calculated mesure object in the universe.

<EXPRESSION>@Select(Key Figures\Order Amount)*@Select(Key

Figures\Order Quantity)</EXPRESSION>

Go through the below link to know how to customize olap universe(from page#427)

http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_designer_en.pdf

Thanks,

Pramod