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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the difference between slice and dice and cross tab report?

605


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

1610


Give some information on report bursting?

567


Explain is data mart?

588


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?

3127






Explain the difference between detect alias and detect context?

620


How to open a universe with out using the Designer ??

6608


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

615


How were the reports scheduled and how to resolve unexecuted documents?

2210


What are all difference between business objects 6.5 and xi r2?

600


can anybody tell me about complicated object you have created

2751


how get the grand total in master-detail report?

1813


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1829


What is the difference between user and versatile user?

577


any difficulitis have you phase while creating bo reports and how did u solve it

2990