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
- 9551 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 |
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
what is maximum scope of analysis --> can we define more than 3 levels?
what is the difference between input file repository server and output file repository server ?
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
Can Bo generates the reports from cubical data ? Explain?
Why do we need metrics and sets?
How many universes can be created in a project?
which is the best way to resolve loop context r alias why?
Explain about a tricky situation for which you found a very simple solution?
What are steps to be taken care to create a good Universe?
Teradata 
