Business Objects - Can you add the Cascading promprts in Business Objects? (Based on Country prompt selection you need

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 14 of 233

Can you add the Cascading promprts in Business Objects? (Based on Country prompt selection you need to provide the option to select Sate/Province in the next State prompt. That means dynamically refresh the data load in the state list values)

Total Answers and Comments: 8

Last Update: April 25, 2008 Asked by: Uma

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 21, 2006 07:26:31

reddeppa

RE: Can you add the Cascading promprts in Business Obj...

i know one approach ..we have to creeate these in Univrse design level..

this makes some process..

that means..we have create objects..ans in conditional we to create prompts..

reddeppa.

9324966949

bangalore

Is this answer useful? Yes | No

March 20, 2006 17:59:45

Nikhil

RE: Can you add the Cascading promprts in Business Obj...

Cascading prompts are not possible in BO till version 6.5 atleast. Cascading has been introduced in XI.

Is this answer useful? Yes | No

March 25, 2006 04:22:22

sithu

Member Since: March 2006 Contribution: 46

RE: Can you add the Cascading promprts in Business Obj...

you can do that using @prompt functionsCheers,Sithusithusithu@hotmail.com

Is this answer useful? Yes | No

March 31, 2006 04:47:18

mahudeswaran

RE: Can you add the Cascading promprts in Business Obj...

if you select one prompt value based on that prompt value gives other lov (that lov value is have relate that 1st prompt value) you can select one or more from that value.

south (region) > tn,ap,kr,kl (state)

north (region) > nd,jk,hr,up (state)

if i select region south i can see only south region state. (this is casecading prompt)

it should create universe level.

double click state object >

edit properties > properties > edit

you can see the query pan, there pulldown that region object and use that prompt conditions and save that

now you click display button you can see how that prompts are working.

mahudes

Is this answer useful? Yes | No

September 13, 2007 08:39:04

Siva

RE: Can you add the Cascading promprts in Business Obj...

First We have to create Condition for one object in universe level like


         State

      Condition

               state = @prompt(...);
then

           That same object will be selected on report level like

        Query Pannel

               City

          Condition


                   state = @prompt(..)

           It Will work as Cascading Prompt.

Is this answer useful? Yes | No

December 19, 2007 22:21:46

ravi_kumar_garre

Member Since: November 2007 Contribution: 33

RE: Can you add the Cascading promprts in Business Objects? (Based on Country prompt selection you need to provide the option to select Sate/Province in the next State prompt. That means dynamically refresh the data load in the state list values)

Cascading Prompts possible in BO 6.5.2 and BOXI R2Â but not in 6.5.1 version.
Â
Cheers,
Ravi Kumar Garre
Phone: +91-9820350246

Is this answer useful? Yes | No

January 03, 2008 16:10:42

antonykumar

Member Since: December 2006 Contribution: 2

Yes, possible through the version XI R2.

1) Create Dynamic Cadaing Parameters(DCP) LOV in Business View Manager XIR2.
2) Schedule the DCP LOV within Business View Manager XIR2.
3) Call DCP LOV within Crystal Reports XIR2.

++Antony

Is this answer useful? Yes | No

April 25, 2008 07:18:02

krvikramraju

Member Since: April 2008 Contribution: 2

I feel you are getting confused with Cascading LOVs and Cascading Prompts.
In Business Objects XI, we have Nested Prompts (which you might call cascading prompts). And this is since 6.x version and there is no change in that.

From XI, they have introduced Cascading LOVs concept.

Is this answer useful? Yes | No

Go To Top