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 |
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
what is casual dimension?
if the project is assigned for you and the client said yo wait for a month,What will you do in that time?
What is the difference between condition & filter?
what is mean by lov?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Explain how to execute the plsql procedure from the report by clicking with mouse?
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
What is Designer?
what is crosstab reporting,slice and dise and drill mode??
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
which is the best way to resolve loop context r alias why?