Insight (OBIEE) Tips for Report Designers
For more Eloqua Insight Resources, please visit: https://community.oracle.com/topliners/discussion/4470627/eloqua-insight-resource-page
Just some random tips that have been on my mind lately... What are your tips that might help others?
Only include the columns that you need
Avoid overcrowding your analysis by including a lot of columns lot of columns in Criteria tab and several different views with many excluded columns.
However, since Insight retrieves results for all columns specified in Criteria tab, creating several analysis with a single view rather will generate more efficient queries (i.e. faster).
Keep your views to a minimum
It is better again to create multiple analysis with the view you need, than building many views in a single analysis. Also, delete views you do need even if you're not using them. Each view may have a cost on performance even if it is not included in compound layout.