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 SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data
What are the Users and User groups?
There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
What Is Snow Flake Schema?
When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
what is maximum scope of analysis --> can we define more than 3 levels?
What is the dense rank?
how to limit number of rows in a report in business objects using webi?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?