Date prompts from EDW Universe object not working fine.

building reports webintelligence
1

Hi .

We have a universe with EDW data as the source. We made a dimension object for a ‘Business Date’. I’m pulling this in the Where clause to give the From Date and To Date prompts.

Business Date BETWEEN ‘From Date’ and ‘To Date’

The problem i’m facing is the prompt work perfectly alright when both prompt values are made mandatory but the result is not AS EXPECTED when we have both prompts as OPTIONAL.

Any suggestions specific to handling DATE objects from BW would really help. yes, this is simple stuff but freaking me out as it’s not working!! :hb:

Thanks,
Keshav

nileena_gp (BOB member since 2011-08-08)

2

That is because you are using the BETWEEN, this ALLWAYS requires two values.
When you want something optional you have to use something like this

startdate >= @prompt(startdate) and enddate <= @promtp(enddate)

HenkK

HenkK :netherlands: (BOB member since 2004-03-02)