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 |
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Can we configure two instances of CMS pointing to two different CMS system databases?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
. User wants to modify a report and wants to add additional data. How will you approach.
Explain the difference between detect alias and detect context?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
what is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
how did u give developed universe to ur client?
wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.
If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.
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 ?
how to improve the performance of the report