Answer / kiruba

create two tables.

one is for 'India/UK'. depend on your selection in the
prompt the first table should show the result. if you
select India the table should show the India result. If you
select UK then the table should show the UK result. that
time hide the second table.

when you select 'ALL' in the prompt, then show both the
tables. use the filter condition 'Country_name = India' in
the first table. us the filter 'Country_name = UK' in the
second table.

But you have to show the results in both the table
when 'Prompt = ALL'.

Answer / kishoe

u can use the combined query to the "ALL" Objects use

Answer / anil kumar ganga

use cascading prompts. If you select India then it wil
bring only corresponding state details.

Answer / narendra

using custom SQL we can achieve this. Country. country
name=@prompt('enetr ur country','A','Classname/object name',
)or ALL=@prompt('enetr ur country','A','Classname/object
name', )

Answer / varun sharma

use matches pattern option to solve ur problem.
in matches pattern ( select country name or % for all).
now if u select particular country name then coresponding
data is displayed else use % to show all data for
country prompt

Answer / stalin

you can achive this through the prompt.

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

2 Answers   Wipro,

What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  

Report have 10000 records,how to restrict the end user to 1000 Records?

6 Answers  

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

Explain about alerts in bos, under what situation we need to use alerts?

0 Answers  

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,

if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  

how we transport universes from business objects 6.5 to BOXI R2?

3 Answers  

How to Shedule the reports in Xi R2

3 Answers   iFlex,