on 11-07-2017 6:35 AM
Hi Experts,
Client have requirement to build universe on top of 3 DB Source's like Oracle and DB2
While building report on top of multi source universe, Report is very slow and getting exit without any data.
Could you please let me know some ways to increase the report performance.
Hi ,
could be issue with APS configuration ! how much memory is assigned to DSL APS ?min 8GB is recommended.
can you run report with "query filters" applied at webi ?
also try with enable "query stripping" at business layer
Regards
Sateesh B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
how many records are in individual tables?
how many table you have joined which are used in report?
is it happening with simple reports also or only specfic to some reports?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.