cancel
Showing results for 
Search instead for 
Did you mean: 

MTD Prompts in SAP BW Universe

Former Member
0 Kudos

Hi, I have a requirement where we have to display the MTD data . We have "Last Business day" in Key Figures. Can anyone guide me how to achieve this in Universe. Basically I want to create a condition in universe which when applied on a Webi Query should return that month's(MTD) data only. I am using BOXI 3.1

Thanks,

Pankaj Goswami

Accepted Solutions (1)

Accepted Solutions (1)

IngoH
Advisor
Advisor
0 Kudos

hi,

the MDX so far does not have a "now" or today which means that functions like a MTD refer to the last data in the InfoProvider. if you want to leverage the actual system data you can leverage EXIT variables in the BW query.

Ingo

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for all yoru replies. We are now getting this from BeX Query.

Former Member
0 Kudos

Hi,

article mentioned by Wond is at that Link: [OLAP universes best practices|http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c8206203eb?quicklink=index&overridelayout=true]

Regards.

Roberto.

Edited by: Roberto G. on Mar 26, 2010 5:34 PM

Former Member
0 Kudos

There is a document online for best practice on universe, there you have all the expressions, but I would recommend you to get the MTD value in BI query, it is much simpler.

thanks.

Wond