OBIEE Performance Tuning:
1.Generally OBIEE Dashboard running slowly as data set of 30 million records,then sequence of performance technieques will be performed like -- Gathering stats,star dimensional modelling instead of snowflake model,bitmap indexes,partioning,parallel query,compression,aggregated tables(MViews),bitmap join indexes.
For Summary reports-- we can build aggregated tables like MVs.
No comments:
Post a Comment