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.
Answer Posted / 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 |
Post New Answer View All Answers
How to open a universe with out using the Designer ??
Explain is data mart?
How to execute the plsql procedure from the report by clicking with mouse?
What Is The Difference Between Oltp And Olap?
Explain how we drill up week to month?
What is difference between webi and infoview?
Is there any other repository domains rather than universe, security, document?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What is the difference between absolute and relative div positioning?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is object stores?
Explain how to schedule the report in b.o?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what are the tables used in health care domain project and columns used in report?
Explain what three things do you consider to be the most important factors for a manager?