Date Prompt

building semantic layer
1

Dear All,

I have created a date prompt for a single day as below, but when I added the prompt to the WebI report it could not fetch any data and if I use the prompt from the report it works fine.

analytics_john.created IN @Prompt(‘Select Date:’,‘A’,‘Analytics John\Date’,MULTI,Free)

Also, I want to create prompt asking for ranges of date. Can some one please help me out.

BO : XIR3 WebI
DB : MYSQL

Thanks,

John

JohnJustus :us: (BOB member since 2007-06-25)

2

Try changing the ‘A’ to ‘D’ for date.

I’ve mentioned your date range with the between functionality in the other thread. :slight_smile:

3

Thanks Mark. I modified to D and works fine for a single date.

analytics_john.created IN @Prompt(‘Select Date:’,‘D’,‘Analytics John\Date’,MULTI,Free)

I looked at the other thread for range of dates prompt. I need to implement the ranges prompt in the above code, so that it can be a stand alone prompt. Is that possible?

Thanks,

John

JohnJustus :us: (BOB member since 2007-06-25)

4 
analytics_john.created BETWEEN @Prompt('Select Start Date:','D','Analytics John\Date',mono,constrained) AND @Prompt('Select End Date:','D','Analytics John\Date',mono,constrained)
5

Awesome Mark. Worked Great.

JohnJustus :us: (BOB member since 2007-06-25)

6

Hi Mark,

Thanks for your help.
Is there any way to create a weekly prompt (say week1,week2,week3,week4) assuming that we have only date columns.

When the user see a chart or report they want to see the values on weekly basis or the user wants to select all 4 weeks from the prompt (Week1,Week2,Week3,Week4)

Thanks,

John

JohnJustus :us: (BOB member since 2007-06-25)

7

Not really, you’ll need to create a date dimension containing week numbers/names

8

Hi Mark,

So, you mean to create additional columns in the table for week right?
Basically, the client says to manage everything in Business objects itself instead of creating columns or tables.

Can you please give me more details, so that I can explain this to the client.

JohnJustus :us: (BOB member since 2007-06-25)