Posts Tagged ‘obiee’

In my last post I detailed the features of Oracle Data Visualization Desktop, which is an added feature that comes with the Data Visualization Cloud Service, Business Intelligence Cloud Service and is part of the Data Visualization add-on to OBIEE 12c.  Even if you don’t have a production license, an evaluation copy can be found on […]

Oracle has expanded its Data Visualization capabilities by releasing Data Visualization Desktop (DVD).  The underlying “Visual Analyzer” technology has been part of the Oracle BI Cloud Service for over a year but is now available as a feature-rich desktop tool.  As of right now, it is included with Data Visualization Cloud Service, Business Intelligence Cloud […]

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 […]

Whenever a Full load is executed, all target tables are truncated and reloaded. This can result in missing historical data in Aggregate or Snapshot tables. Once erased, such historical data cannot easily be replaced. In order to preserve Account Payables (AP) and Account Receivables (AR) Snapshot data from aging invoice tables W_AP_AGING_INVOICE_A and W_AR_AGING_INVOICE_A, OOTB […]

In this 20-minute demo, watch how Perficient can accelerate your adoption of a state-of-the-art Sales Analytics solution leveraging Oracle’s BI Cloud Service and Perficient’s long history of implementing BI solutions for the Sales Line of Business. If you are a VP of Sales, a Sales Manager or an individual Sales Rep, you will find this BI solution valuable for staying on […]

It’s been a busy year in the Enterprise Information Systems space. With over 75 posts this year, our in-house experts found themselves face to face with big changes and an abundance of great information to share. We sifted through that content and present to you the Top 10 EIS posts of 2015.   Ten | […]

Mazen just previewed What to Expect Next on BICS and now it is in the process of being released.  The first thing you’ll notice is the new clean and concise consumer-style user experience.  Site navigation and the Home page has changed dramatically as you can see in the screen shot below (the compass next to the user’s name brings up […]