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.
Re: 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.
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.
Re: 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.
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.
Re: 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.
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.
1. I have 2 universes. that is u1 and u2. From u1,i created
one report that is r1. Now i want to give the connection r1
to u2 and at the same time delete the connection from u1 to
r1 ? How is it possible explain?
2.How can i schedule the reports in BOXIR2?