Error while connecting to essbase from FR

Hi,

This is the error that me and and some of my friends faced while connecting to Essbase from Financial Reporting Studio, while creating grid... Logging into FR studio is working fine that means HSS is up and running but while creating a report in FR when we drag a grid and try to connect to some essbase server it is throwing an Error: " Can't connect to server" so, new server connection is not getting established. Here is the solution :

1. Check if you can connect to any other Essbase server from Studio. If yes, then check if you are using correct login credentials to connect to essbase. Also, try to connect to that essbase server using your login credentials from Excel Add-in or SmartView or AAS.

2. Check if all BI+ Services are up and running on Server.

3. Stop and Start BI+ services in the following order:
1. BI+ Core Services
2. Workspace
3. Financial Reporting Java RMI
4. Financial Reporting Print Server
5. Financial Reporting Report Server
6. Financial Reporting Scheduler Server
7. Financial Reporting Web Server

5. If still problem exists, run config utility for BI+, and re-configure Database with Drop all tables option.

Cheerz!
-CJ

Oracle Schema Query for creating Schemas for Hyperion Installation

Hi,

Here is the query:

create user HSS identified by password;

grant dba to HSS;

create tablespace HSS
datafile 'D:\Oracle\hyperionfiles\HSS.dbf'
size 30M
Autoextend on
Extent Management local

/

alter user hyptt default tablespace HSS;

Hyperion Product PORTS

Hi,

Below is the list of ports used by Hyperion.

Port Type Default Port Number Where Configurable

Shared Services Ports

Listen port 58080 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console.
Shutdown Port for Apache Tomcat 58081 Default ports are supplied by the application server. To modify, see the application server documentation.
AJP connector port 58082 Default ports are supplied by the application server. To modify, see the application server documentation.
Hyperion Remote Authentication Module 58000 Hyperion Remote Authentication Module installation program
OpenLDAP 58089
Hyperion License Server (lmgrd) 27000
Hyperion License Server (HYSLD) Dynamic

Analytic Services Default Service Ports

Analytic Services Agent 1423 Hyperion Configuration Utility
Analytic Integration Services Server 3388 /bin/ais.cfg
Add -Pportnumber

Analytic Administration Services Web Application Ports

Listen port 10080
SSL listen port 10090
Shutdown port for Apache Tomcat 10005

Analytic Provider Services Web Application Ports

Listen port 13080
SSL listen port 13090
Shutdown port for Apache Tomcat 13005

BI+ Default Service Ports

Foundation 6790 — 6810
Global Services Manager (GSM) 6800
Core Service 6801
Name Service 6798
Service Broker 6797
Job Service 6796
Event Service 6794
Repository Service 6795

BI+ Web Server Port

Apache and IBM 19000 /conf/httpd.conf
IIS 80 In Microsoft Internet Information Services (IIS) Manager Console, change the TCP port value setting.

Financial Reporting Web Application Ports

Listen port 8200 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console
Shutdown port for Apache Tomcat 8201
AJP connector port 8202

Financial Reporting Default Service Ports

Financial Reporting Report Service Dynamic (2)
Financial Reporting Scheduler Service Dynamic
Financial Reporting Print Service Dynamic
Financial Reporting Communication Service 8299

Interactive Reporting Default Service Ports

Data Access Service (DAS) 6811, 6812
Interactive Reporting Service 6813, 6814
Job Service 6815
Log Service 6810


Web Analysis Web Application Ports

Listen port 16000 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console
Shutdown port for Apache Tomcat 16001
AJP connector port 16002

Workspace Web Application Ports

Listen port 45000 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console
Shutdown port for Apache Tomcat 45001
AJP connector port 45002

Financial Management Default Service Port

Financial Management Application Server 135 plus ephemeral high-range ports (1024–65536) Fix DCOM ephemeral ports in Windows settings. See the Microsoft support article describing how to set the ports used by DCOM: http:// support.microsoft.com. Search for "restrict DCOM port".

Financial Management Web Server Port 80 In Microsoft Internet Information Services (IIS) Manager Console, change the TCP port value setting.

Planning Web Application Ports

Listen port 8300 Hyperion Configuration Utility
SSL listen port 8303 Application server administration console
Shutdown port for Apache Tomcat 8301 Default ports are supplied by the application server. To modify, see the application server documentation.
AJP connector port 8302 Default ports are supplied by the application server. To modify, see the application server documentation.

Planning Default Service Port

Planning RMI Server 11333 /common/RMI/ HyperionRMIRegistry.properties

BPM Architect Web Application Ports

BPM Architect UI
Listen port 19091 (can be configured for SSL) Hyperion Configuration Utility
SSL listen port 19094
Shutdown port for Apache Tomcat 19092
AJP connector port 19093


FDM Web Application Ports

Listen port 135 plus ephemeral high-range ports (1024–65536).
SSL listen port
Shutdown port for Apache Tomcat
AJP connector port

FDM Default Service Ports

FDM load balancer 135 plus ephemeral high-range ports (1024–65536)
FDM application server 135 plus ephemeral high-range ports (1024–65536)
File sharing 137–139, 445
Firewall 135 plus ephemeral high-range ports (1024–65536)

FDM Web Server Port

80 (HTTP) or 443 (HTTPS) In Microsoft Internet Information Services (IIS) Manager Console, change the TCP port value setting.

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