Posts Tagged ‘Oracle BI Applications’

Since 2007, many companies have adopted Oracle BI Applications as the foundation for their data and analytics platforms. Today, Oracle considers the platform to be content-complete with controlled availability and the final version scheduled to release in mid-2020. Existing customers are strongly advised to take a proactive approach to defining and executing a go-forward strategy […]

If you missed our webinar, A Customer’s Take on Moving from Discoverer to Oracle Business Analytics, the on-demand recording is now available for immediate viewing. If you are currently using Discoverer, hear directly from a Perficient customer, Gary Aragon with Group Voyagers, who made the move from Discoverer to Oracle Business Intelligence Enterprise Edition (OBIEE) in […]

Perficient is exhibiting and presenting this week at KScope17 in San Antonio, TX.  I delivered my presentation yesterday on modeling complex data security in Oracle BI.  Here is the abstract for my presentation: Learn how to build a position based security model to enable a position can view all it’s direct reports’ marketing/sales performance; learn […]

When planning an out-of-town vacation, do you diligently ensure that you have someone lined up to water your plants, feed your goldfish, and keep an eye on your home?   What about your Hyperion environment? Do you hire a managed services provider to take care of your systems and watch over your applications while you are […]

Effective and efficient financial reporting is crucial for the success of semiconductor companies.  It is critical to track revenue, shipments, and order backlogs in order to properly utilize company assets.  In addition to understanding the current financial position of the company, there needs to be visibility into company forecasts in order to do proper financial and manufacturing planning. Data […]

In Part 1 of this series, I explained how to prepare your system for VirtualBox and download and extract the .ova file from the Oracle OTN site.  This post describes how to deploy the image, setup the virtual machine settings, how to set up your network adapters and run a critical patch.  At that point […]

This post explains the process of using ODI Export Multiple Objects utility to export selected multiple ODI objects and importing them individually. ODI introduced a new feature ‘Smart Export’ from version 11.1.16, This feature automates the process of exporting/importing all objects related to your change, As BIAPPS OOTB ODI repository contains thousands of objects smart […]

This post will explain the process to raise the custom exception in ODI. Process: Create a variable to store the custom error message Create a procedure to read the error message from the variable and raise the exception. Create a package to set the value in the custom error variable and execute the raise exception […]

This post explains the process to unload ODI session log information Ex:  Session name, run-time, number of records inserted etc. from SNP_SESSION table to a delimited file and attach it to a Load Plan success notification email. This attachment can be used to identify the Session’s which are running longer than usual and causing performance issues, […]

When it comes to choosing the right Cloud BI platform, there is usually a trade off between governance and centralization on one hand and agility on the other. BI software vendors like Tableau and Qlik, that are relatively newer to the game than traditional BI platforms, have changed the rules of what defines a better BI […]

In BIAPPS whenever a ODI package is executed it reads  W_ETL_LOAD_DATES table to verify if a record exists with that package name. If record found package is executed in incremental mode else Full load mode. In incremental mode package will update the last_executed_date of existing record in W_ETL_LOAD_DATES table and in Full load mode package will insert […]

This post explains the process to unload an error message from ODI repository log tables SNP_LPI_STEP_LOG, SNP_LPI_EXC_LOG to .txt file and attach it to a Load Plan failure notification email. Process: Create ‘Error_Notification’ package which uses ODISqlUnload utility to unload error message from log tables and write into text file, OdiSendMail utility to send email […]