Configuring FDM with Oracle Database

Hey All,

I have started this blog for people working in Oracle Hyperion. In my blog I will write about some technical tips and stuff related to HYPERION.This is my first post..
I observed that many Hyperion guys are finding difficulty in configuring FDM with Oracle as a backend. People are facing errors like "Schema/user already exists".Also I noticed that in Hyperion guides there is no information available to configure FDM on oracle. I am giving detailed info. regarding creating DB/schema on oracle for FDM so that even a person with no/very less knowledge of Oracle DB can also create it. Here is the solution:

Following are the steps to create database on Oracle for FDM :

1) Create a general purpose database using create database wizard of Oracle.

2)Connect to SQLPLUS using system/oracle to Database ( Provide database name as a Host String in SQLPLUS Login screen)

3)Create a new user/Schema:
Syntax: Create user username IDENTIFIED BY password
Default tablespace users
Temporary tablespace temp;

4)Grant unlimited tablespace to new user.
Syntax: Grant UNLIMITED TABLESPACE to username;

5)Grant following accesses to new user

i. CREATE PROCEDURE
ii. CREATE SEQUENCE
iii. CREATE SESSION
iv. CREATE TABLE
v. CREATE TRIGGER
vi. CREATE VIEW
vii. QUERY REWRITE

Syntax: GRANT CREATE PROCEDURE to username;

6) Use this new user while creating a FDM application.

Cheerz!

---CJ