Skip to main content

Posts Tagged ‘OBIEE 11g’

Web API Using Azure

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

agile backlog groom

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

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

Purge Cache Automation in OBIEE 11g

Why do we Purge Cache Automatically? The cache option in OBIEE 11g can help us to improve query performance greatly. But sometimes when we refresh the data mapping or reload the transaction data, the result over report will be out of date and not refreshed immediately due to cache. The best way is that we […]

Handy OBIEE Tricks – RR_4035 SQL Error / ORA-00911: invalid character

On my current project I am implementing OBIEE with OBI Applications I am running the Data Warehouse Administration Console and Informatica 9.0.1 HF2 on Microsoft Windows Server 2008 R2 Standard Edition. Once I followed all of the installation and configuration steps I was able to run my first full execution plan to […]

OBIEE Project Log, Part 1: Operating Systems

Welcome to my Oracle BI Project Log series. This will be an open ended series related to decisions made and lessons learned in a live Perficient project. I will be focusing on the technology questions which should be generic to any OBIEE implementation. Which Operating System Should We Use? If a client has a […]