Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9979 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 traffic lighting in business objects?
Explain what is the difference between slice and dice and cross tab report?
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
Tell me about linked universe ?
Who launches the supervisor product in Business Objects for first time?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?
What are the steps to be taken to schedule the report?
how can u find the granularity in fact table
What is Complex Reports?
what is the source for metrics?
What is package in BO
Teradata 
