on 12-13-2011 9:29 AM
Hi All,
Can we Universe connect to multiple databases? How to improve performance of Webi report (Which one is best Query level ya Report level filter )?
Thanks & Regrads,
Hi,
Yes, you can in BI 4.0 , Information Design Tool (IDT)
From here, you can create a MultiSource Universe (MSU), which can combine various relational connections into a single data foundations and single business layer (.UNX universe)
Regards,
H
p.s. a query filter does filter the dataset at the source; whereas a report filter simply hides rows in the presentation layer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create synonyms for those tables at schema which you have used for your universe; then import those tables in your universe, link them with existing structure or create a derived table or create a view in database and import in universe. Then use your universe for reporting.
Regards,
Avijit
Hi
If you want to have a universe pointing at diferent databases, then you can't do it.
One Universe = one database.
And Query Filter used to restrict(filter) data coming from database . In report level the values are not restricted it shows all the values .hence performance degradation occurs .
so finally query filter is best .
Hope this helps
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ..
you can connect one database for one universe.. can't connect multi database to one universe... But you can create the reports using multi universe for one report.
Query level filter is recommended for report instead of report level filter.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.