YTD, MTD, Prior Year, Prior Month calculations in SAP BW Universe
I am finding the SAP BW based universe a totally different animal so far and my question comes from my inexperience in this domain.
In a normal universe, one can use CASE Statement and Calendar or Time table to help do these calculations. Since BW based universes are based on a super BEx query, how are these calculations done in the universe? Are these calculations done in the BEx query itself?
Are there any standards of what should be handled on the BEx side vs. what should be handled on the Universe side?
Also, what's the syntax of a CASE statment or using Substring (or similar function) in a BW universe?
p.s. Moderator, I posted this thread in universe design forum and then later realized that there is a specific forum for integration kits and SAP realted stuff. My apologies for this.
Edited by: Kashif Saeed on Sep 9, 2008 9:23 PM
I published a document on SAP site that five you samples of MDX expressions as well as recommendations and hints and tips when using calculted measures and filters in OLAP universes.
Here is the link: https://boc.sdn.sap.com/node/20081