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
- 7977 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 |
What is the dense rank?
What we need to discuss with designer before starting the universe designing.
Can anybody tell me about issues faced while creating universe. thanks in advance
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
HOW TO SPOT A HIERARCHY?
if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode
What would you consider as your biggest achievement and why?
How to create Universe using Flat file in BO6.0
How to resolve the partial result error in the report
what is traffic lighting in business objects?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Teradata 
