Example Country Name is like India/UK or ALL
In parameter I selected India or UK it should show only
perticular country details in BO.If i select ALL in
parameter.It should show both country data in different
tables.
Answers were Sorted based on User's Feedback
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'.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kishoe
u can use the combined query to the "ALL" Objects use
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anil kumar ganga
use cascading prompts. If you select India then it wil
bring only corresponding state details.
| Is This Answer Correct ? | 2 Yes | 4 No |
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', )
| Is This Answer Correct ? | 0 Yes | 2 No |
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
| Is This Answer Correct ? | 0 Yes | 4 No |
What is the user Object ? What is the need of it?
What is the profile and package?
Difference between Decode and Case?
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
how we transport universes from business objects 6.5 to BOXI R2?
How to get the data from the two different sourcess
how to restrict up to three levels in hierarchy when u do drill mode?
how to coneect to a server in a business objects
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
how to solve the incompatible objects and how they are formed actually.
Explain about a task that really tested your analytical abilities?