on 02-09-2011 3:15 PM
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.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Hi,
Try creating a new Object in the Universe and Select: getdate()
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I would recommend to use EXIT Variables as part of the BEx query in BW.
ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
Currently there is no equivalant of sysdate() available in the SAP MDX engine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.