When creating a one line table in Oracle BI Publisher using a Data Table, it will give you redundant filtering options on the titles of the table and an unnecessary subtotal at the end of the table if there is a fact in the table. Instead, we would like to have a similar table but without the filters and the subtotal. To do this we will add a Layout Grid to the dimensions that we have predefined. This will give the overall BI Publisher report a much cleaner look by removing two of the features of the data table. … Read More
An Analysis Design that will Allow Users to Create Custom Reports in OBIEE
Recently, I have been toying with the idea of having an OBIEE report that would allow the users to customize which columns would be shown in a particular report. This idea was going to be hard to execute because allowing users to customize the report that they would want to see on a dashboard would require the XML driving the analysis to change dynamically. A solution to this problem will not give the user 100% control of which columns are added to a report but it will allow them to have more control creating a report that they’re interested in. … Read More
Is Oracle’s Vision Corp Guilty of Gender Inequality? An OBIEE Analysis to Investigate Reports
Allegations of Vision Corporation’s activity in gender salary discrimination is something that Oracle’s Vision Corp takes very seriously and have been generous enough to open up all of their information for independent analysis by the public. We will begin an investigation of their full time employee’s salary information to see if the allegations of gender salary discrimination are prevalent in this corporation. We will be using OBIEE 11.1.1.6.0 to investigate. The first thing we will look at is a generated table and pie chart that calculates the number of employees by their gender. We can see that there is a … Read More
Enabling the Auto-Complete Prompt Functionality in OBIEE 11.1.1.6
OBIEE 11.1.1.6 has an auto-complete prompt feature which when enabled allows users to begin typing a selection in the prompts and OBIEE will suggest and highlight the matching prompt values. This option is only available on the “Choice List” when “Enable user to type values” is selected. When the following code is implemented will also allow the auto-complete to be case insensitive. 1. Navigate to: 1 $MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1$MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1 2. Open instanceconfig.xml file (make a backup of the file prior to making any changes). 3. Add the following code between the <ServerInstance> … </ServerInstance><ServerInstance> … </ServerInstance> tags: <Prompts> <MaxDropDownValues>256</MaxDropDownValues> <AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues> <AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox> <AutoCompletePromptDropDowns> … Read More
Installing Oracle Database 11g XE and Unlocking the HR Sample Schema – A Tutorial with Screenshots
When learning to develop Oracle Fusion applications, one of your first steps, if not already completed, should be to install a database for your applications to connect to. Oracle ADF applications are capable of connecting with several different database technologies, but perhaps the most conducive is Oracle’s own database suite. Oracle offers several different database solutions with varying levels of functionality. Oracle’s free, entry-level database offering, Oracle Database Express Edition (XE), is a very capable platform which should provide ample power for development purposes. Oracle Database XE does have some performance limitations which are described in Oracle XE Limitations (CPU, … Read More
Modifying the Caching Parameters for OBIEE 11g
The Oracle BI Presentation Services caching could be an issue with high volume and large queries. A solution may be to limit the amount that can be cached. Currently, the default maximum entries are set at 500 for a maximum of 60 minutes. The path of the BI Presentation cache is found in: 1 ORACLE_INSTANCE\tmp\OracleBIPresentationServices\coreapplication_obipsn\obis_tempORACLE_INSTANCE\tmp\OracleBIPresentationServices\coreapplication_obipsn\obis_temp One way of working around this would be to limit the caching parameters in the BI Presentation Services by modifying the instanceconfig.xml file in the following path: 1 ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsnORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn 1. Open the instanceconfig.xml file 2. Locate the section in which you must add the elements … Read More
Creating a Run Button on a Dashboard in OBIEE 11g
When preparing an analysis, we may not be interested in having all of the data queried for a particular report and you also do not want to require a field for a user to compete in order to run a query. This is one proposed option to fix this issue, we will need to re-purpose a field in our analysis, filter it, and create a required prompt on the dashboard. The first part of this exercise we will set up the analysis and in the second we will set up the prompt for it. Preparing the Dashboard’s Run Button: This … Read More
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