Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

Hi Kashif,

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:


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question