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 |
What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
How to hide the table s in webi?can any one tell me plzzzzzzzz
Explain how we drill up week to month?
what is dashboards? what is metrics?
what is difference between folders and category ?
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
What is DSS?? (Defination of DSS)
What are the difference between merge,auto merge and extended merge ?
what is meant by report busting
What is the use of BO SDK?