Query Filter in XI 3.1

building reports webintelligence
1

I have a table in the database “Activity”

Activity line Activity name
1 A
1 B
1 C
2 D
2 E
2 F
2 G
3 H
3 I

I have created a class Activity with objects activity line and activity name in the universe.

Filter : “Enter activity line” Equals 1 It is not a prompt.
The next Prompt is " Select activity name" Which is a prompt

My question is In the activity name promt in the LOV only values “A,B,C”

should be shown.
(1) can this be achieved using sub query ?

If yes can u can let know how to create this sub query in 3.1

which object should i pull first in the filter pane and what to do next.

(2) and also since these 2 objects belong to same class do i need to do anything thing on the linkage at the universe level or by default if you filter on activity number in the subquery only those activity names pertaining to that number will show up?

itchel (BOB member since 2010-05-26)

2

Edit the LOV of this object to show the limited values.

Jansi :india: (BOB member since 2008-05-12)

3

For each level ie 1,2,3 iam creating a new report ,but the problem is we have almost 100 activity names for each level.

Is their an other way to do this apart from editing the lov’s?

itchel (BOB member since 2010-05-26)

4

HI Itchel,

Create Cascading List of values. That will solve your problem.

Let me know your thoughts.

M H Mohammed :us: (BOB member since 2010-06-16)