u drag 2 sources from 2 diff dataproviders,how we take
these 2 sources into 1 single report,
how we give the link these 2 sources
Answers were Sorted based on User's Feedback
Answer / kvchowdary
by using data synchronization process..that means....
synchronization is the term used to describe the merging of
data from multiple data sources into a single block in a report
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / suvarna
You can do a trick. Suppose u have different objects in
two data providers (lets dpA and dpB),dpA have product
related objects for example product code, product name 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.
For this , go to the tool bar->view data->definations->
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 ? | 6 Yes | 0 No |
Answer / sunil sethi
Both of the above answers are correct.it get linked
automatically if the objects have the same name in 2 data
provider.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravi
Basically we merge objects from two or more queries in one
webi report, so that we can use them in same block.
Mandatory condition to merge objects is to have Same data
type
Normally Merged dimension will work as Left or Right outer
join and not as Full outer join.
If you want to use Full outer Join you can use extended
merge dimension Values option in document properties .
| Is This Answer Correct ? | 0 Yes | 0 No |
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
how to link 3 fact tables
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
What is the difference between the public object&schema object?
what is BIAR file in business objects xi r2
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
Who launches the supervisor product in Business Objects for first time?
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
can i use stored procedure in webi?