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.
- 6 Answers
- 8583 Views
- TCS, I also Faced
- E-Mail Answers
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 thumbnail?
am a fresher hw to get real time experience?
I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps
what is zero client and thin client ?
any difficulitis have you phase while creating bo reports and how did u solve it
how many user were there
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?
can you use inputbox in BOXI. e.g. checkbox,textbox etc.
9.what are the multidimensional analyses
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
How will you test a BO report
Teradata 
