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
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 |
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
What would you consider as your biggest achievement and why?
When is the Repository created?
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
what is main functional differences between BO and COGNOs?
if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
How to Shedule the reports in Xi R2
How we drill up week to month?
I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?