Mithil Shah

Publisher can be used to share and distribute reports. Scheduler is a quartz based scheduler for reporting jobs. In this post we will look at sending a report to a user via mail using the scheduler and publisher.Steps1. Login to BI publisher. If you face any problems during login, use the following troubleshooting optionshttp://forums.oracle.com/forums/thread.jspa?threadID=582633&start=0&tstart=60http://oraclebizint.wordpress.com/2007/11/06/oracle-bi-publisher-and-bi-ee-invisible-admin-tab/http://onlineappsdba.com/index.php/2009/01/15/oracle-bi-publisher-admin-console-xmlpserver-login-issue-administratoradministrator/2. Note … Read more

In this post we will look at creating and using a session variable to implement row level security in answers. Situations where this is useful is:1. Allowing user to see data that she has access to.2. Showing data based on current date.3. A sales manager can be shown data in his region only. A CEO … Read more

We will create and use a dynamic repository variable in the dashboard. The aim is to show current time in the dashboard.We use the variable in two places. First is in the title of a reportThe second is in the narrative text. Steps:1. Create a dynamic repository variable that obtains the latest time. we will … Read more

Caching can be used for queries that are run repeatedly. Look at this blog to understand how to enable and configure caching. In this post we will look at pre-caching a query. Lets look at the foodmart catalog that we created in the earlier postWe will pre-cache the result of this reportSteps1. Create a text … Read more

We look at creating a rank measure in this post. We will use the sales_fact_1997 table for this example. Join the sales_fact_1997 table with the product, store, time_by_day and promotion table in the physical layer. Drag the sales_fact_1997 and product table to the logical layer and create appropriate joins.We will create a salesRank logical column … Read more

This post continues the idea of drill down developed in the previous post. Lets say that in addition to the country and city we also need to drill down on year->month. We will add a column selector to the existing report. here are the steps to do it.1. Add the time_by_day table to the business … Read more

In this post we look at creating a level based hierarchy and generate a drill down report off that. We will use the FoodMart database (described in previous posts). Take a look at the inventory_fact_1997 table and the store table. our aim is to find the units_ordered for the following hierarchy in the store table … Read more

In the previous post we created the physical model by importing the table schema from the database. Next we will create the logical model for the inventory_fact_1997 table and connected dimensions.1. Select the following tables from the physical layer and drag them to the logical model layer.inventory_fact_1997productstoretime_by_daywarehousemake sure that you drag all the tables at … Read more

OBIEE stores its physical and logical schema in a repository. The repository is a file with an extension of .rpd In this post we look at creating a new repository and importing the physical schema metadata from the foodmart datasource created in the previous post.1. Open the Oracle BI server Administration page. Go to Start-> … Read more

We will be using the sample food mart database for all tutorials. Please look into the introduction blog to obtain the link for this database.In this post we look at creating a datasource to the foodmart database in MySql. The screenshots are from a windows XP machine.Steps to create the data source.1. Goto Start -> … Read more