cancel
Showing results for 
Search instead for 
Did you mean: 

Current Date , Current date - 45 days

Former Member
0 Kudos

I have a bex query which brings for last three years of data (with mandatory date range prompts). I want to use the same cube and create Universe level conditional objects like : Current Date and (Current date - 45) .I want use this in condition in webi query panel. I will make the optional prompts for date range.

Do you recommand this approach.How to create newobjects like Current Date and (Current date - 45)

Thanks

Pats

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

The MDX function Now() that returns the system date is not supported by SAP.

The only solution in your case is to write a user exit.

Regards,

Didier

Answers (0)