Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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.

Answers were Sorted based on User's Feedback



Hai, Can anyone tell me 'how to use one dataprovider result as an input to another d..

Answer / sathish arichandran

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

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another d..

Answer / jansi

Select query result option is not available in Web-I

Is This Answer Correct ?    3 Yes 2 No

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another d..

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

Post New Answer

More Business Objects Interview Questions

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

0 Answers  


HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  


What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  


Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  


i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)

0 Answers  


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,


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

0 Answers   Infosys,


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

0 Answers   HCL,


REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 Answers  


How will you move reports from Dev to QA in BO

3 Answers   Infosys,


how to overcome overflow of data in a report

6 Answers  


What is Universe?

1 Answers  


Categories