OBIEE – Column vs. Variable Prompts

When using dashboard prompts in OBIEE Analytics, you are given access to a few different types of prompts to choose from. Two of these variations will be the focus of this discussion, column and variable. If you have never used both types, it’s difficult to understand the key difference, and why one prompt type may be more useful than the other in certain situations. Column Prompt The column prompt is the more basic of the two being discussed today. This type of prompt holds a value of a chosen field from a specific view that will be passed to the filter inside of an analysis. … Read More

Adding an Alias table within the BI physical layer using Oracle BI Administration Tool

When you are starting to put together a business layer from a physical data layer that has tables with self-referential integrity, you may find aliasing the table helpful in laying out the clean data model. The example below uses an EMPLOYEE to MANAGER relationship on the EMPLOYEE table where the MANAGER_ID references back to the EMPLOYEE_ID on the same EMPLOYEE table. Using the alias feature helps separate these self-referential relationships into their own tables and allows ease of use on the presentation layer. We will be working with tables from the HR Schema (In the Oracle APEX XE Database) to … Read More