IDT date filters

building semantic layer
1

If I run a webi query with a query filter between two date prompts, I get a pop-up calendar and the option to input a date and a time.

If I create a prompt at universe level and make it of data type DATE, there is no option here to specify whether or not I want the time element. At webi runtime, I get the pop-up calendar again but no option to input a time element. BUT I can manually type a time - it doesn’t show in the left hand pane of the prompt window, but it does appear in the SQL generated.

Confusing!

Debbie

Debbie :uk: (BOB member since 2005-03-01)

2

Hi Debbie ,
Doesn’t @Prompt(‘DateTime Here’,‘DT’, ) get you the datetime prompt? For just a date its ‘D’ , for datetime , its ‘DT’ .

Shobhit_Acharya (BOB member since 2005-08-11)

3

As a function, yes. But I tried to set up my prompts as parameters on the DF layer where it’s just a dropdown of DATE, NUMERIC and STRING.

I’m not entirely sure what the difference is between a standalone prompt and a parameter prompt (which is what I appear to have created).

Debbie

Debbie :uk: (BOB member since 2005-03-01)

4

I’m a bit old fashioned (unv biased) that way. Never really put parameters on the data foundation layer. Its supposed to be a “reusability” driven feature. i.e if that DF gets used in many blx’s the parameters show up in all the business layers.

Shobhit_Acharya (BOB member since 2005-08-11)

5

That was the idea. Trying to create reusable bits and do it all “properly”…

Meh. Not sure why I’m bothering!

Debbie

ETA: Gave up and gone back to doing it the old way. Much simpler…

Debbie :uk: (BOB member since 2005-03-01)