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
- 9731 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 |
when you have three fact table and there is no relationship between them. How you will tackle the issue.
Can we link the oracle and excel universess?
Explain about derived tables?
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
what are cascading prompts explain with steps
what are the documentations u r created?
how get the grand total in master-detail report?
how can i add two different reports in the same document?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
what is document design in boxi,have u participate in that
Teradata 
