Days Between 2 Dates

[Former Member]

Hi all,

I am using SAP Cubes for Universe .

my senerio i want block some details if more than one year old as as on date.

means

current date - tansaction date >365

please give me syntax for the same in OLAP Universe.

[Former Member]

Hi,

Can you clarify a little bit what are you expecting as query result?

By the way, OLAP data sources and SAP do not provide functions for current date (system date).

I suggest that:

- First, you build a universe on SAP BW then create a Web Intelligence document with a query that retrieves what you need.

- Then, in Web Intelligence document you define local variables using "CurrentDate()" to compare with the dates you have retrieved by using for instance Min and Max functions

Didier