I have built my first Web intelligence report. However I need to filter the quesry to run only yesterdays information (today’s date -1). The universe does have current date already built in. My question is how do I get that added?
Do I add another query using the universe that holds the current date dimension? Do I combine the query? Do I use a variable editor in the report to filter once query has run.
You’ll need to have an object built in the universe that returns yesterday’s date. Then you can set a query filter where your date object = Yesterday’s Date.
Just to add to Michael’s comment, something that I do a lot in universes is add lots of generic dates to the universe so that these can be used by any report where required.
I normally create a separate class for these objects and I would include dates like:
Today,
Yesterday,
Last Week,
Last Month (First and Last days)
3,6,9 & 12 months ago.
This is usually my starting point and I will add from here.
I go a step further and have a date universe for oracle and date universe for SQL server. Then I just link the appropriate one to whatever universe I’m using and the dates are all there for me.
To true, I had thought about this also and probably should do this before I get to far into reporting with the dates for my many universe, but will probably wait till we upgrade to BI 4.0 and do it as part of that change.
(BOB member since 2002-08-08)
(BOB member since 2004-03-22)
(BOB member since 2005-03-01)
(BOB member since 2004-03-22)