Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9619 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 |
How to restrict password to a user while sending a document in .pdf format
what is casual dimension?
In Business Objects 4.1 version what is the alternative name for broadcast agent?
How to fix the order of Prompts? How to assign the default value in prompt?
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
Is there any other repository domains rather than universe, security, document?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
What is the prm file ? can anybody explain me ?
Can we get the data from two different databasess in reporting level?
WHAT IS SAP BO AND BO?
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
Teradata 
