Archive for 'OBIEE Administration' Category

Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet?

By Dhwani Shah - Last updated: Tuesday, May 26, 2009

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

By Dhwani Shah - Last updated: Friday, February 20, 2009

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

By Dhwani Shah - Last updated: Friday, December 19, 2008

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