Introduction OBIEE: Oracle Business Intelligence Enterprise Edition Plus, also termed as theOBI EE Plus, is Oracle Corporation’s set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings. Tableau: Tableau Software is a software that produces interactive data visualization products focused on business intelligence. MSBI (SSRS): This powerful suite is […]
Avik Dutta
Avik is working as a Solutions Architect in Oracle BI practice in Perficient Inc. in Colorado, United States. His primary role is to lead, design & implement end to end BI projects: starting from estimation, requirement gathering, hardware sizing, design, development, testing phase, go-live, support, user training and finally handover. Avik's experience includes managing and leading small to moderate sized teams focusing primarily into OBIEE/OBIA. Avik has ~ 10.5 years of experience in DWBI domain with industry knowledge in Healthcare, Recruitment, Retail, Pharmaceutical, Education, Telecommunications, Media and Entertainment, Tours and Travels, Shipyard Constructions, Financial Services and Health Insurance. Avik has worked in different modules such as Finance, HR, Supply Chain Management, Projects, Procurement & Spend, Sales and Marketing, Student Analytics etc. In these years Avik has worked extensively in OBIA (7964 and 11g) - OBIEE (12c, OAC, BICS, 11g, 10g), BI Publisher (10g, 11g, 12c), SAP BO 4.0, BO XIR2, CR XI, SSRS 2008R2 and in PL/SQL as well. Other than these Avik has working knowledge of Informatica, ODI 11g and IBM Datastage as well.
Blogs from this Author
Configuring Windows Services for OBIEE 11g
Introduction When Oracle Business Intelligence is started, few services will start. These are Node Manager, Admin Server, Managed Server. Starting all these services require manual effort. So these components will start once the server is restarted by a Developer or Admin person. To overcome this dependency on manual intervention, all the OBIEE services are created […]
OBIEE 12.2.1.2.0 Installation and Configuration (Win 2012R2)
System Requirements The system requirements for Oracle BI Applications installation: Oracle Fusion Middleware requires a minimum 1-GHz CPU Windows minimum physical memory required – 4 GB. Windows minimum available memory required – 8 GB. Additional System Requirements and Supported Platforms for Oracle Business Intelligence EE Release 12.2.1 can be found in Oracle Fusion Middleware 12c (12.2.1.0.0) […]
OBIEE Design and Development Best Practices
Introduction This document is for Oracle Business Intelligence Enterprise Edition (OBIEE) Developers and Designers. These standard guidelines may vary from project to project. Below mentioned OBIEE Standards are more in generic form & developers can follow these guidelines to standardize their code & minimize post development defects. Repository – Physical Layer best practices Database […]
OBIEE 11g Portal Customization
In order to best deliver an intuitive and interactive end-user experience, architecture and UI elements have been redesigned from the ground-up in Oracle Business Intelligence Enterprise Edition 11g Release (Oracle BIEE). The 11g UI is dynamically generated using scripts which makes it highly customizable as per client’s needs and standards. This blog post illustrates the […]
OBIEE 11g – Deployment of Custom Skins and Styles
Introduction OBIEE has a set of styles and skins to make the displaying of data visually appealing. This gives the user the ability to select styles as per their need. Generally, in OBIEE 12c, the default UI Skin and Style is called ‘Alta’. In 11g, it is ‘blafp’. Customers most often want to see their organization’s […]
Configure OBIEE Cache Purge with Event Polling Table
Introduction An event polling table (S_NQ_EPT) is a way to identify for the Oracle BI Server that one or more physical tables have been updated. Each row that is added to an event table highlights a single update on a single table. The cache system reads from this table, extracts the information from these rows, […]
OBIEE Automated Cache Purge Using ODI
The OBIEE BI Server cache is the most effective way of improving response times of OBIEE dashboards followed by database modifications and tuning. Using data present in the cache limits the load on the database considerably. It is also effective for improving network, BI server and dashboard performance for obvious reasons. However, after a certain […]
OBIEE 12c Security: LDAP Authentication and DB Authorization
OBIEE 12c by default uses WebLogic internal user directory for security purposes. This is effective only when the number of the users is very limited and is not expected to grow much over the years. But, in a real world business scenario, almost all implementations require configuring a more robust way to implement authentication and […]
Usage Tracking – OBIEE 12c
Usage tracking in OBIEE 12c is very similar to that in 11g, which enables mainly administrative users to track all reports being run and queries fired to the database. It is also very helpful in identifying and analyzing objects that require better query performance. The configuration steps will be mentioned in this blog as well as […]
Configuring and Integrating Google Maps into OBIEE 11g
Introduction: When Oracle Business Intelligence is installed, functionality for users to see maps that display data is also installed. Before users can see maps in analyses and dashboards, one must understand the system requirements, specify layers and maps, and configure the metadata. This post will explain the steps to configure mapping and spatial information for […]
Multi-User Development Set Up Using OBIEE Administration Tool
Introduction Multi-user development (MUD) provides a mechanism for concurrent development on overlapping code bases. Oracle Business Intelligence provides a MUD environment that manages subsets of metadata, in addition to multiple users, by providing a built-in versioning system for repository development. By default, the Oracle BI repository development environment is not set up for multiple users. […]