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.