You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Insight (OBIEE) Tips for Report Designers

13
Views
0
Comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!