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.
- 5 Answers
- 7967 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / narsi
in BOxir2 wise it is possible. would u have base uni &
dervied uni's. i think ur requirement is solve by
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.
u go for deski, select "datamanager" --> click "link to"
Option it is possible.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / naresh
It is possible only if one object each from each universe is
of same data type and then linking those objects from Data
Manager as said above.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / swetha
You can do by synchronising both data providers i.e.
you need to use LinkTo command buttion in ViewData option
by matching corresponding dimensions that have the same
data type.
by default Null Values also placed in the report.then you
can use NotIsNull option to avoid Nulls.
Thanks,
Swetha
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / suvarna
You can do a trick. Suppose u have different objects in
two data providers (lets say dpA and dpB),dpA have product
related objects for example product code, product name etc
and dpB have customer related objects.U drag a object from
a dp, lets take dpA.
Now when u try to drag a object from dpB u will not be able
to do that.
For this , go to the tool bar->view data->definitions->
link the object u want to drag(say customer name from dpB)
with any object from dpA ->select Ok.Now u will be able to
drag the customer name from dpB. U will see that data
displayed in the report is not correct.Now again go to view
data and unlink the objects->select Ok.
Now u will get the correct data in the report.
| Is This Answer Correct ? | 0 Yes | 4 No |
difference between xir2 and 6.5 version
Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?
What are steps to be taken care to create a good Universe?
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
How many universes are required for a single project,and how many reports are required for a single Universe.
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What are alertors in Business Objects?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
What are the types of errors you faced while creating a report from two different data providers
I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Teradata 
