Skip to Content
Former Member
Aug 16, 2009 at 11:42 PM

SAP BW OLAP Universe: Calculated objects



We are using BOE XI 3.1 on a SAP BI 7 environment, building an OLAP universe on BEX query for Webi. We are testing creating calculated objects on the universe level referring to the "OLAP universe best practice" and "xi31_sap_olap_universes_en.pdf". Not getting much success, here are some questions:

1) Where to put the XML/MDX code? The "xi31_sap_olap" says to put the code in the WHERE: clause (SELECT: box is blank?), but this does not parse nor does it work.

2) Tried putting this into the SELECT clause:

<EXPRESSION>(@Select (Key Figures\Number of Actions),[0CALYEAR].[2008])</EXPRESSION>

Result = Object does not parse, but universe will return results to Webi. The expected result is "Number of Actions" restricted to CALYEAR = 2008, but results are erroneous scattered into other years.

3) <EXPRESSION>SUM(YTD(@Select (Key Figures\Number of Actions)))</EXPRESSION>

Result = Does not parse, gets MDX error and does not run

4) <EXPRESSION>((@Select (Key Figures\Number of Actions), [0CALYEAR].[2008], [0CALQUART1].[Q1]))</EXPRESSION>

Result = Does not parse, gets MDX error and does not run.

Any information or help would be appreciated, thank you.