how can we build one report from two data bases
Answers were Sorted based on User's Feedback
Answer / ramesh reddy veerabhadra
We could not link two universes which have different
databases. Designer will not allow to link them by using
the parameter option. Here we can link the universe who
have same database.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / g.v.subramanyam
in boxi r/2, by using businessviewmanager(window based
tool)we can retrive the data from two databases.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / tarukhemu
Create report by taking 1st query from 1st universe. Then 'Add Query' and select 2nd Universe there. This will give you data from two different universes. This works even if the two universes are pointing to different database connections.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sreekarbo
i have a solution like, v can create two universes from two databases and then link the universes. By using the link option in universe parameters. Then we can sync the data in report based on common object.
| Is This Answer Correct ? | 3 Yes | 6 No |
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How to restrict password to a user while sending a document in .pdf format
What are templates? Explain what you have created?
What is the use of AFD? Where it can be stored?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?
it is possible to link two universes of separate functional domain ?
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
5.what is LOV? where it is store?
What are the join problems comes appart from loop,chasm & fan Traps
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
What are the major problems will occur while migrating to the one version to another version?