BusinessObjects Board

How to restrict the unvalid lov values inthe prompt selction

building reports webintelligence
#1

Hi All,

I have 3 objects, “Department”, “Dept-start date”, “Dept- end date”, “Period”.
Department have values: ‘A’, ‘B’, ‘C’, ‘D’…
Dept-Start date: 20091001, 20091101, 20091201, 201001….
Dept-End date: 20091029, 20091130, 20091230, 20101029….
Period: 200910,200911, 200912, 201001……

So table look like.
Ex: Department ---------------Start date--------------End date
----- A ---------------------20091001-------------20091029
----- B -----------------------20091101-------------20091130
------ C -----------------------20091201--------------20091230
------ D -----------------------20100101--------------20100129

I have prompts in the report on “Period” and “Department”.
Period inlist (“Enter the Period”)
AND
Department Inlist(“Enter the Dept”).

So if I select the prompt for period then department prompt should show valid values. I mean if i select the period equal to 200911 then automatically the Department prompt values should show “B”.
If I select Period=201001, Department Prompt values should show “D”, then I have to select the “D” and run the report.

I have created the cascading but its not working.
I am using BOXIR2, Oracle.
Please help me. :hb:

srinu.bos (BOB member since 2007-06-06)

#2

Can i get any help?

srinu.bos (BOB member since 2007-06-06)

#3

Hi srinu ,

AS per your problem statement I think the most apt solution would be creating a cascading LOV for your two objects at Universe Level .

Go to the Department Object and edit Lov for it and Put a Prompt for Period Over there .

Hope It helps

Regards
Sapan

swapnil_taz :india: (BOB member since 2006-04-06)

#4

Firstly, don’t bump your post, its against the forum rules, thanks :).

Secondly, please give more detail, with regards to what you have tried, then you are more likely to get some assistance.

Mak 1 :uk: (BOB member since 2005-01-06)

#5

HI,
I have 3 prompts for my report.
Period inlist (“Enter the values”), ex: 200910,200911,200912,201001…
And
Department inlist(“Enter the Dept”) Ex: A, B, C, D ……
AND
Sub-Department inlist(“Enter the subdept”) Ex: a1,a11, b1,b12, c1,c13, d1………

We have Start date and End date for each Department and Sub Department.
Start date: 20091001,20091101,20091201,20100101……….
End date:20091030,20091129,200912131,20100129……….

Please find below table for easy understand.

Department ------- Subdepartment ------- startdate -------- enddate

-------- A ------- -----------a1 --------- ---- 20091001 ----------- 20091030
--------- A -------------------a11 ---------- 20091201------------ 20091231
-------- B -------- ---------- b1 ---------- ----- 20091001------------- 20091030
-------- B -------- ---------- b12 ---------- 20091101 --------- — 20091129
-------- C -------- ---------- c1 -------------- 20100101 --------- — 20100129
-------- C ---------------------c13 ---------- 20100101 --------- — 20100129
-------- D -------- ------------- d ---------- 20100101 --------- — 20100129

So my requirement is, if I select the period prompt 200910 then automatically next Department prompt should show valid Department in the prompt list. Valid means the selection period between or equal to department startdate and enddate.
Then after selecting the valid department then next sub-department also show valid list.

Ex: if select
Period =200910 then department prompt list should show Department= A,B and the sub-department prompt should show “Sub-dept= a1,b1”

Period=201001
Department= C,D
Sub-depart= c1,c13,d

So I have to restrict the lov values before select the prompt.

I have applied the Cascading on period, department and sub-department, but department was showing valid departments but subdepartment was showing all subdept(not valid).
If changed the cascading order to Period, Sub-Department and Department, then Sub-Department was showing valid subdepts but Department was showing all departments.

Please let me know if not clear.

srinu.bos (BOB member since 2007-06-06)

#6

Thanks for the explanation, it is far clearer now :).

I don’t think that you can do what you want unfortunately.
Good post here:-

https://bobj-board.org/t/140891

Mak 1 :uk: (BOB member since 2005-01-06)