Follow the latest in AI
Setting up R-Java in Netbeans is pretty straight forward. For those who need a walkthough here are the steps. Download and install R (for this example version 2.12.2). install rJava package. Download and install Netbeans. In Netbeans Create a new java project. we will call it RJava. From the [R_HOME]>/library/rJava/jri/examples folder, copy the file rtest.java … Read more
Update – Check out the new RJava Eclipse Plugin.The steps to install rjava on a 64 bit machine is not very different from installing it on a 32 bit machine. however, here are the exact steps. 1. Install 64 bit java.2. Install R 2.12.X3. Start R and install the rjava package using the package installer.4. … Read more
In this post we look at installing and configuring Oracle BI Applications. I managed to install the application on an intel core 2 duo laptop with 2 GB RAM, Windows Vista machine.We would need source data to view the dashboard for BI apps, the source data can be obtained from Oracle E business suite vision … Read more
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