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 ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1749


what are the day to day activities of BO administrator ?

1980


How would you format some text using css to be verdana and bold?

674


What is top business?

569


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602






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?

549


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1433


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1973


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1588


how many reports have u created ? explain a few.

1667


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

696


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

555


Can Bo generates the Report from the cubical data Explain?

1628


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1972


How to restrict password to a user while sending a document in .pdf format

1865