In a report i want to fetch teh data from 2 data Providers.
which condetion wil satisfy to link the 2 data providers.

ex: Q1 have columns A,B,C
Q2 has a X,Y,Z columns.

requirement is like i want to get all the columns from
those 2 tables in report level..like A,B,C,X,Y,Z in a
single report.

Answer Posted / narsi

in BOxir2 wise it is possible. would u have base uni &
dervied uni's. i think ur requirement is solve by
go for deski, select "datamanager" --> click "link to"
Option it is possible.after use using "combining query"
option & just select "union"
operator wise ur query is solve.

anotherwise u go for webi, select "MERGE" option it is
possible.

otherwise, ur requirement is not possible. because ur
columns names are not maching.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the join problems comes appart from loop,chasm & fan Traps

1556


U r project in which stage in implementation?

1950


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

3928


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?

3135


How to generate the report from excel sheet?

586






What is the difference between slice and dice and cross tab report?

607


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

609


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

556


Explain difference between zabo and webi?

656


Explain is data mart?

597


Can you please send me the migration related issues .

1651


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1818


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

621


Explain about a time when you discovered a more efficient way to do a work task?

643


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

9443