KPI Partners Blog

Using OBIEE Session Variables in Select Tables in the Physical Layer

Posted by KPI Partners News Team on Mon, Aug 02, 2010 @ 09:14 PM

By Kurt Wolff

There are many times when it is very beneficial to pass the value of session variables (or report variables) into the SQL used to define a Select table in the physical layer. This allows the select statement to focus on just the data you want, rather than creating a view with potentially millions of rows and then subsequently applying a filter to that result set.

Read More

Tags: Oracle BI, Blog