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

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3213


Explain about a task that really tested your analytical abilities?

869


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1738


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9625


Explain is there any other repository domains rather than universe, security, document?

663






How to schedule the report in b.o?

651


What we need to discuss with designer before starting the universe designing.

1914


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1696


What is Indexing? how did u implement indexing?

1885


Can anybody tell me what are the tuning problems?

1676


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1648


Can we configure two instances of CMS pointing to two different CMS system databases?

1584


What is object stores?

662


What three things do you consider to be the most important factors for a manager?

707


Explain which versions are used in the bo dashboard work?

723