cancel
Showing results for 
Search instead for 
Did you mean: 

Current Date Object

Former Member
0 Kudos

Hi,

i´d been searching for this for a long time but still don´t get it! how do i create a new object @universe level wich only delivers the current date or sysdate? i´d read a lot about SYSDATE but no change...

does the universe support objects that do not reference to a current object member but rather calculates the current date via MDX?

by the way a need to create such an object @universe, not within the bw query.

Thanks a lot for help.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Create an object date1 of type date.

In select clause,

dim_date.calendar_date

in where clause,

to_char(dim_date.calendar_date,'dd-mon-yyyy') = (select to_char(sysdate-1,'dd-mon-yyyy') from dual).

Hope this will solve your problem.

Acc to my knowledge, We can't use directly currentdate() function in universe.

This link may be help you:

http://www.gulland.com/wp/?p=18

Former Member
0 Kudos

Swarna,

I know how to create it in a database environment; I'm after doing it in a SAP BW environment.

In fact, I wouldn't even do it the way that you've suggested; I'd create a yesterday object and use that in the conditions section of the query

Edited by: Me map on Mar 22, 2011 10:35 AM

Former Member
0 Kudos

Right, I've had a good look into this today.

It appears that the only option at the data provider layer is to have separate Bex queries with exit variables for each date range - yesterday, week to date, month to date, quarter to date, this year, last year, etc.

Result of other query doesn't appear to be an option either.

I've got other ideas to look at though as the exit variables option seems to be a bit of a clunky way of doing it.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Try creating a new Object in the Universe and Select: getdate()

Mike

IngoH
Active Contributor
0 Kudos

Hi,

I would recommend to use EXIT Variables as part of the BEx query in BW.

ingo

Former Member
0 Kudos

Ingo,

How would you suggest exit variables help?

Would this mean that you'd have to write a Bex Query for each time restriction?

For example, if I wanted to write a sales report for yesterday's sales, I could then easily do that in Webi over a universe derived from a RDBMS source and just alter the date to be last week, last month, current month, current quarter, current year and so on. Would these need to be separate queries from BW?

Former Member
0 Kudos

Currently there is no equivalant of sysdate() available in the SAP MDX engine.

Former Member
0 Kudos

...ok many thanks for this information.

that means actually there is no way to create a current date object @universe (OLAP)?

Former Member
0 Kudos

I think you'd have to use CurrentDate() in the report

I would imagine that it's in hand for XI4.....

Scheduled reporting's going to be fun, isn't it!