Row level security (constraining a user’s view of the data to rows which meet pre-defined criteria) is a common requirement. 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.
Read More

May 8th, KPI Partners broadcast a webinar which demonstrated how KPI's pre-built solution can extend Oracle BI to support analysis of educational institutions.
Read More
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?
Read More
What is Business Intelligence? Listen to a brief history of BI, where we've been, where we are now, and where we are going...
Read More
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.
Read More
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.
Read More
Don't let the name fool you. Lightweight Directory Access Protocol (LDAP) is no lightweight.
Read More
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).
Read More