Hi,
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.