BusinessObjects Board

Prompts and LOVs

building reports desktopintelligence
#1

Hi all,

I need one clarification : In prompts for eg

I have objects called Fund name , Unitholder name and balences .
I have prompts at universe level for fund name and unitholder name .

In the report i took all the 3 objects Fund Name , Unit Hoder Name and Balences and put the prompts for Fund Name and Unitholder Name.

When i try to run the report , I am getting the prompts for Fund name and Unit Holder names .The 2 prompts are giving some values to select in the fom the list of values.

But my question is among all the fund names if i select one fund is it possible to show only unit holders who invested in that fund at the time of selecting the unitholder name from unitholder prompt instead of showing all the unitholder names.

Regards
Chandra

vcoreddy11 (BOB member since 2006-09-02)

#2

What you’re looking for are Cascading Prompts. These do not work well in the BO classic products.

Read the FAQ in the Semantic Layer forum and you’ll see what you need.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

Here is the link…

CASCADING PROMPTS…
https://bobj-board.org/t/15227/8

BO_Chief :us: (BOB member since 2004-06-06)