When reports take long time to return results, generally we have to tune the performance of OBIEE or Data sources.
When reports start pulling data, 99% of process takes place on the underlying data sources only.
From database(oracle) side, some of the ways to improve the performance are Removing snowflakes,Star transforamtion, Partitioning, Adding Indexes, Denormalization, Aggregation (Using materialized view).
From OBIEE side, some of the ways to improve the performance are Caching, Thread pooling, Scaling out(Adding additional instances), Load balancing.
When reports start pulling data, 99% of process takes place on the underlying data sources only.
From database(oracle) side, some of the ways to improve the performance are Removing snowflakes,Star transforamtion, Partitioning, Adding Indexes, Denormalization, Aggregation (Using materialized view).
From OBIEE side, some of the ways to improve the performance are Caching, Thread pooling, Scaling out(Adding additional instances), Load balancing.
Post a Comment