Archive for 'OBIEE Administrator' Category
Usage Tracking in OBIEE
How to enable usage tracking in OBIEE ?
How to perfrom usage audit in OBIEE ?
OBIEE Services
Below is the list of OBIEE components (programs) and services responsible to run them. Below article is based on Windsow environment. 1) Oracle Business Intelligence Server (Oracle BI Server) 2) Oracle Business Intelligence Presentation Services (Oracle BI Presentation Server) 3) Oracle Business Intelligence Javahost (Oracle BI Java Host) 4) Oracle Business Intelligence Scheduler (Oracle BI [...]
Importing / Creating Users in OBIEE+
Requirement : Often time its really a pain to create users in bulk.So below script will be helpful to create users with default password. Step 1: Create the script as shown below. This script basically creates a declaration syntex for OBIEE. Run the SQL Command like to Generate the File Called : userImport.udml (or you [...]
Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet?
I got one question like this,,, “Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet? ” Here is the Answer. Yes we can import data from multiple sheets from an excel file . Here are the steps Step 1) Create system DSN for Excel [...]
Aggregate Persistence Wizard in OBIEE
Aggregate Table (Aggregate Persistence Wizard) Aggregate Table: Aggregate tables store precalculated measures that have been aggregate over a set of dimensional attributes. This is very useful technique for speeding up query response time in decision support systems. This eliminates the need of run time calculations and delivers faster results to users. The calculations are done [...]
Authentication In OBIEE
People often ask question below for authentication in OBIEE Question : What are the different ways to authenticate an user in OBIEE system? Can OBIEE authenticate a user passing through multiple authentication methods? Which one is the best long term? OBIEE Support four types of authentication. 1)LDAP Authentication : Users are authenticated based on credentials [...]
OBIEE LDAP Authentication using Microsoft AD 1
How to Implement Single Sign On (SSO) in OBIEE with Microsoft Active Directory ? OBIEE LDAP authentication using microsoft Active Directory. Before starting this, I would prefer that you read my article on session variable and initialized block here SSO can be implemented using Lightweight Directory Access Protocol (LDAP) in OBIEE. Most popular LDAP implementation [...]