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
- 9526 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 |
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?
Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
can any body tell me how to create Hyperlinks in BO XI R2?
If there is no common dimension? Is it possible to combine two different dataproviders?
What are the steps to taken care to improve the Report performance?
Report have 10000 records,how to restrict the end user to 1000 Records?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
5.what is slowly changing dimension ?
1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?
1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?
Teradata 
