Insight OBIEE - Tips & Tricks

With Insight, users can easily create ad-hoc analyses, drill down into data, and visualize results through a variety of charts and graphs.

Here are a couple of easy to apply formulas and functions for your daily contact, email and form reports:

• Comparing two date fields and using CAST function to remove the timestamp.

If you’re interested in comparing two date fields, for example, check if a contact has been created in the contact table and in your main CDO in the same day, ignoring the timestamp value, the following New Calculated Measure SQL Case Statement can be of help.