cancel
Showing results for 
Search instead for 
Did you mean: 

OLAP Universe MDX functions

Former Member
0 Kudos
45

Hello experts,

We have a requirement to apply a filter based on report run date in comparison with date objects as follows:

(Report Run Data - 90 days) < System Completion date < Report Run Date

Any any one help me how we can implement this in Conditions at OLAP Universe.

Regards,

Ravi Kumar Garre

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member793810
Active Contributor
0 Kudos

Hi,

Here is a document whic lists lost of example.

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,

Bashir Awan

Former Member
0 Kudos

Hi Ingo/Experts,

I have already gone through the given OLAP Univerese best practices document and found few MDX experessions on Dates like CDate which supports only Microsoft Analysis but not SAP BW.

Appreciate your help and suggestions with alternative solutions if any.

Regards,

Ravi Kumar Garre

IngoH
Active Contributor
0 Kudos

Hi,

such functionality needs to be done with EXIT variables because in the MDX there is no option to use something like a "today()"

ingo

Former Member
0 Kudos

Thanks Ingo.

Regards,

Ravi Kumar Garre