Profile cover photo
Profile photo
Rahul Bhattacharya
Computer Engineer | Programmer | Writer | IT Industry Pro
Computer Engineer | Programmer | Writer | IT Industry Pro

Rahul Bhattacharya's posts

Post has attachment
OBIEE Dashboard Export to Excel PDF HTML using Custom Links
Oracle Business Intelligence Application in it's out of the box form do not provide any solution to export a dashboard from another dashboard using custom links. But given the available resources, it is possible to create custom links to export a dashboard ...

Post has attachment
DRM Data Loading Automation using ODI
The Oracle Hyperion Data Relationship Management application is a pretty flexible tool and most of the activities that can be done manually can be automated (using ETL tools like ODI, Informatica PowerCenter, etc). Recently I was presented with a business s...

Post has attachment
Oracle BI Apps dynamic hierarchy filtering in ODI incremental load plan
Oracle Business Intelligence Applications often sources data from various systems and it is often required to restrict or allow various dimension information during the loading processes. There are a variety of ways this can be done, let's take a walk throu...

Post has attachment
Managing BI Services using ODI
Oracle Data Integrator is one of the widely used tools for data loading into the Oracle Business Intelligence data warehouse. Often it happens that due to frequent data updates in the source systems, the data needs to be refreshed in the data warehouse duri...

Post has attachment
Sqoop Import and Export tables from Hive to Oracle Database
Exporting and Importing table data from Oracle database to Hive and vice-versa is one of the most common activities in the world of Hadoop. It is essential to get sorted out on a few basics for seamless first time integration so as to avoid various parsing ...

Post has attachment
How ODI IKM SQL to Hyperion Essbase (METADATA) influences data loading
Oracle Data Integrator integrates with Essbase for metadata as well as data loading using different Knowledge Modules. Each of the KMs provides a range of options for us to customize the loading as we want. The IKM SQL to Hyperion Essbase (METADATA) is usua...

Post has attachment
ODI Automation of Smart View Manual Activities
Oracle Data Integrator provides multiple features to automate almost all manual data extraction and transformation related activities. One such scenario is using Smart View to manually fetch data from the Essbase cubes, maybe weekly or monthly. Often such c...

Post has attachment
Troubleshooting Hive in Hortonworks Virtualbox Sandbox
While getting started with Hadoop, the sandbox provided by Hortonworks is an easy to use starting point. Once we download the Virtualbox, we can easily import it into our existing VirtualBox Manager. This is assuming we already have a VM VirtualBox Manager ...

Post has attachment
Type 2 Slowly Changing Dimension - How ORA_HASH (mis) fits in
The ORA_HASH is one of my favorite functions to generate a hash value and use it for that record in a variety of ways. But there are certain circumstances where even an useful function like ORA_HASH can have it's limitations. Let's take a look at how this f...

Post has attachment
ODI Executions Parametrization - Pros and Cons
The Oracle Data Integrator scenarios and load plans provides a range of flexibilities when it comes to the executions. We can select the Context, Log Levels, provide values as input parameters as required, and all these add to the versatility of this tool. ...
Wait while more posts are being loaded