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 & Tricks

71
Views
0
Comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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