KPI Partners Blog

Using WITH in Physical Tables ("Opaque Views")

Posted by KPI Partners News Team on Fri, May 24, 2024 @ 02:15 AM

by Kurt Wolff

Common practice is to use derived tables (sometimes referred to as “inline views”) when creating a physical layer “Select” table.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Evaluate With Date Functions in OBIEE

Posted by KPI Partners News Team on Fri, May 24, 2024 @ 01:56 AM

by Kurt Wolff

If you’re not concerned about database portability – for example, you use Oracle and that’s that, forever – then the evaluate function in OBIEE can be useful. However, using the evaluate function can be tricky, and the documentation could be better.

Read More

Tags: Kurt Wolff, Oracle BI, Blog