on 02-27-2012 8:14 PM
Hello Gurus,
1.Can we Create a new Object at Universe designer on top SAP BW.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.