by Kurt Wolff
Suppose you have a series of datetime pairs in Oracle BI... The problem is to display the differences between DATE1 and...
by Kurt Wolff
Suppose you have a series of datetime pairs in Oracle BI... The problem is to display the differences between DATE1 and DATE2 in days, hours, minutes, and seconds.
by Kurt Wolff
Row level security (constraining a user’s view of the data to rows which meet pre-defined criteria) is a common requirement...
by Kurt Wolff
Row level security (constraining a user’s view of the data to rows which meet pre-defined criteria) is a common requirement in OBIEE. This post will explore this topic, using a simple schema with a single fact table and three dimension tables, built around the theme of retail sales.
by Kurt Wolff
Suppose you have a dashboard with three pages (tabs). Suppose further that not every user should see all three tabs. Most...
by Kurt Wolff
Suppose you have a dashboard with three pages (tabs). Suppose further that not every user should see all three tabs. Most users will see a limited set of the tabs – some will see two, some will see only one. You want to define web groups to cover all the possible combinations. How many web groups would you have to create?
by Kurt Wolff
If you have tried to develop dashboards or coherent sets of reports as an analytic application, you have had to think about...
by Kurt Wolff
If you have tried to develop dashboards or coherent sets of reports as an analytic application, you have had to think about how best to structure a web catalog.
On March 6th, KPI Partners broadcast a webinar which demonstrated how organizations can dramatically improve the effectiveness of their...
On March 6th, KPI Partners broadcast a webinar which demonstrated how organizations can dramatically improve the effectiveness of their sales people by analyzing Salesforce.com data with Oracle BI.
by Kurt Wolff
Stephen Few designed the Bullet Graph as a way to display measurements vs. goals or other benchmarks. The screen shot below...
by Kurt Wolff
Stephen Few designed the Bullet Graph as a way to display measurements vs. goals or other benchmarks. The screen shot below shows bullet charts in the column “MTD & Proj Comp MAgo” (Month to Date and Projected Expense Compared to Month Ago).
by Kurt Wolff
An OBIEE dashboard designer recently asked how to turn a prompt for a single month into a filter for a range of months. For...
by Kurt Wolff
An OBIEE dashboard designer recently asked how to turn a prompt for a single month into a filter for a range of months. For example, if the user selects “Aug” in the prompt, the results should include not just August but also the three months preceding and following August (i.e. May through Nov).
by Kurt Wolff
One of the tricky things for users of relational databases is forming queries without overstating (or understating) results...
by Kurt Wolff
One of the tricky things for users of relational databases is forming queries without overstating (or understating) results as a consequence of table joins.
On January 10th, KPI Partners broadcast a webinar which took a deep dive into their exclusive pre-built solution for Manufacturing...
On January 10th, KPI Partners broadcast a webinar which took a deep dive into their exclusive pre-built solution for Manufacturing Analytics. Pavan Nanjundaiah, KPI's resident expert on the subject, demonstrated how this solution can help existing customers of Oracle BI Applications further extend their decision support capability.
by Kurt Wolff
Linear regression is a statistical technique for drawing a line through a set of data points that “best fits” the data. It...
by Kurt Wolff
Linear regression is a statistical technique for drawing a line through a set of data points that “best fits” the data. It is a useful and standard technique for quantifying trends.
by Kurt Wolff
Suppose you have a series of datetime pairs in Oracle BI... The problem is to display the differences between DATE1 and DATE2 in days, hours, minutes, and seconds.
by Kurt Wolff
Row level security (constraining a user’s view of the data to rows which meet pre-defined criteria) is a common requirement in OBIEE. This post will explore this topic, using a simple schema with a single fact table and three dimension tables, built around the theme of retail sales.
by Kurt Wolff
Suppose you have a dashboard with three pages (tabs). Suppose further that not every user should see all three tabs. Most users will see a limited set of the tabs – some will see two, some will see only one. You want to define web groups to cover all the possible combinations. How many web groups would you have to create?
by Kurt Wolff
If you have tried to develop dashboards or coherent sets of reports as an analytic application, you have had to think about how best to structure a web catalog.
On March 6th, KPI Partners broadcast a webinar which demonstrated how organizations can dramatically improve the effectiveness of their sales people by analyzing Salesforce.com data with Oracle BI.
by Kurt Wolff
Stephen Few designed the Bullet Graph as a way to display measurements vs. goals or other benchmarks. The screen shot below shows bullet charts in the column “MTD & Proj Comp MAgo” (Month to Date and Projected Expense Compared to Month Ago).
by Kurt Wolff
An OBIEE dashboard designer recently asked how to turn a prompt for a single month into a filter for a range of months. For example, if the user selects “Aug” in the prompt, the results should include not just August but also the three months preceding and following August (i.e. May through Nov).
by Kurt Wolff
One of the tricky things for users of relational databases is forming queries without overstating (or understating) results as a consequence of table joins.
On January 10th, KPI Partners broadcast a webinar which took a deep dive into their exclusive pre-built solution for Manufacturing Analytics. Pavan Nanjundaiah, KPI's resident expert on the subject, demonstrated how this solution can help existing customers of Oracle BI Applications further extend their decision support capability.
by Kurt Wolff
Linear regression is a statistical technique for drawing a line through a set of data points that “best fits” the data. It is a useful and standard technique for quantifying trends.
