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...
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.
By Kurt Wolff
A common question is whether OBIEE can display a table and freeze the header “like you can in Excel”. OBIEE does not offer...
By Kurt Wolff
A common question is whether OBIEE can display a table and freeze the header “like you can in Excel”. OBIEE does not offer that feature out of the box, but you can do this (more or less) with the narrative view and the appropriate html.
By Kurt Wolff
In addition to familiar SQL aggregation functions such as Sum, Max, Min, Average, and Count, OBIEE also supports an...
By Kurt Wolff
In addition to familiar SQL aggregation functions such as Sum, Max, Min, Average, and Count, OBIEE also supports an aggregation function called “Aggregate”. This function is available for use in formulas written in Answers.
By Kurt Wolff
What is the formula behind a measure? What is the source of the column in the report? These kinds of questions could be...
By Kurt Wolff
What is the formula behind a measure? What is the source of the column in the report? These kinds of questions could be handled in multiple ways. The data dictionary feature is one, although a common reaction to the data dictionary feature is that it’s more suited to IT than to the business users. Another way is to present a “tool tip” in Answers (the text of which comes from the Description property of the logical or presentation column in the metadata). However, many users do not have access to Answers or mainly encounter the columns while perusing reports in a dashboard.
New Oracle Business Intelligence Application Designed to Track Performance Throughout Project Life Cycles
To help organizations gain...
New Oracle Business Intelligence Application Designed to Track Performance Throughout Project Life Cycles
To help organizations gain greater insight into project performance, Oracle today introduced Oracle(R) Project Analytics, a new component of the Oracle Business Intelligence (BI) Applications, which monitors key project performance metrics and enables users to control project costs and improve project performance and profitability.
Oracle Project Analytics is one of two applications newly introduced with the general availability of Oracle BI.
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.
By Kurt Wolff
A common question is whether OBIEE can display a table and freeze the header “like you can in Excel”. OBIEE does not offer that feature out of the box, but you can do this (more or less) with the narrative view and the appropriate html.
By Kurt Wolff
In addition to familiar SQL aggregation functions such as Sum, Max, Min, Average, and Count, OBIEE also supports an aggregation function called “Aggregate”. This function is available for use in formulas written in Answers.
By Kurt Wolff
What is the formula behind a measure? What is the source of the column in the report? These kinds of questions could be handled in multiple ways. The data dictionary feature is one, although a common reaction to the data dictionary feature is that it’s more suited to IT than to the business users. Another way is to present a “tool tip” in Answers (the text of which comes from the Description property of the logical or presentation column in the metadata). However, many users do not have access to Answers or mainly encounter the columns while perusing reports in a dashboard.
New Oracle Business Intelligence Application Designed to Track Performance Throughout Project Life Cycles
To help organizations gain greater insight into project performance, Oracle today introduced Oracle(R) Project Analytics, a new component of the Oracle Business Intelligence (BI) Applications, which monitors key project performance metrics and enables users to control project costs and improve project performance and profitability.
Oracle Project Analytics is one of two applications newly introduced with the general availability of Oracle BI.
