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.
- 3 Answers
- 6655 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
In XI R2 webi there is a function called Dataprovider SQL().
It returns the sql query as an output in string format. You
can use this sql to another data provider for an input. I
hope this will help you. Revert back to me once you use this
option
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / natarajan
In BO XIR2 report designer window, you have an option called
Combine Queries. Using that, its possible to source the
output of one query as an input to another query. Combine
query gives features to do a union, intersection or minus.
Intersection query will help to select common rows from two
different queries, which I think is the solution for your query.
| Is This Answer Correct ? | 1 Yes | 5 No |
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
What are the errors u have faced in creating reports in business objects and explain some?
What are the Users and User groups?
How do u Receive requiremnts from the client?
How to create Universe using Flat file in BO6.0
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
how to optimize the query perfomance in b.o?
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
5.what is slowly changing dimension ?
Teradata 
