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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we Save (save as) WEBI Doc as DESKI?

7614


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10395


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2036


Explain what is aggregate table and aggregate fact table ... Any examples of both?

860


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1966


Explain about a time when you discovered a more efficient way to do a work task?

887


U r project in which stage in implementation?

2228


Explain how to execute the plsql procedure from the report by clicking with mouse?

840


What would you consider as your biggest achievement and why?

822


How many universes can be created in a project?

815


How we drill up week to month?

846


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

925


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1790


how to create reports on screech?

2289


What is Indexing? how did u implement indexing?

2048