Custom List of Values for the Prompt

[Former Member]

Hello Experts,

Is there any way that I can create the List of Values with Weekly or monthly range?

Like
7-11-2011 to 13-11-2011
14-11-2011 to 20-11-2011
21-11-2011 to 27-11-2011

and similary for monthly List of values.

Thanks in advance

[Former Member · Accepted solution]

If i understand correctly your question. You have an object that be default has the below lOV's

Object1 LOV's

07-11-2011

14-11-2011

21-11-2011

if so create another object that would give you the date at the end of the week so for above LOV's the new object should have the below list of Values. You can get the below object using the below object definition

@select(object1)+6

Object 2 Lov's

13-11-2011

20-11-2011

27-11-2011

once you have created the above object you can go in to the properties of Object1 click edit to modify Lov

add Object2 to the Lov query and click run you should get the desired result.

Hope this is helpfull

[Former Member · Accepted solution]

Thanks Tauseef.

The object has the values

01-01-2011

01-02-2011

03-03-2011

And if I do as you suggested, then it would look something like below...correct ?

01-01-2011 - 01-07-2011

01-02-2011 - 01-08-2011

01-03-2011 - 01-09-2011

But how do i display the lov like in this way

01-01-2011 - 01-07-2011

01-08-2011 - 01-14-2011

01-15-2011 - 01-21-2011

Getting my point?

[Former Member · Accepted solution]

you do not want to have a dash between the date ranges since the value i believe you want to pass in the filter is still 01-01-2011 as in you last message if you have the dash it would change to string data type and not date.

Based on what i mentioned earlier it will give you the appearance as below with no dashes between the two dates

Display

Date1        | Date2

01-01-2011  01-07-2011

01-02-2011  01-08-2011

01-03-2011  01-09-2011

[Former Member · Accepted solution]

Ok, no dashes.

But how do i get in this format?

  Date 1     |   Date 2

01-01-2011  01-07-2011

01-08-2011  01-14-2011

01-15-2011  01-21-2011

as you can see my first date starts on 1st Jan, say thats Monday and next date is 8th Jan again Month, and third 15th Jan - monday.

[Henry_Banks]

Hi,

IN BI4.0 Information Design Tool, you can create a custom LOV by importing a .txt file if you need.

Regards,

H

[Former Member]

Hi Henry,

How do I do that?

Do I have to create custom LOV for all the Weekly ranges for all the year in a text file?

[Henry_Banks]

IDT > Business Layer > Parameters > LOV > etc etc

it's entirely up to you how you define it.  It's rows of free text.

Regards,

H

[Former Member]

Good to know that .

Thanks