Hyperion On-Premise, Cloud and OneStream

Saturday, April 11, 2020

Hyperion DRM Logo change - DRM Web Url

To change DRM Web Url Logo, go to below path on DRM Server

D:\Oracle\Middleware\EPMSystem11R1\products\DataRelationshipManagement\client\web-client\Images\Blaf

Rename logon_panel.gif file as logon_panel_bkp.gif, place your Logo file in the sam efolder and name it as logon_panel.gif.

Refresh web url page, you can able to see DRM Web page with New Logo.

Thanks,
Madhusuhdan

Friday, April 10, 2020

FR studio not showing up in Hyperion Workspace

FR studio not showing up in Hyperion Workspace. If you are not able to see any clients in Hyperion workspace, like in below screen

Go to Workspace -- Navigate -- Administer -- Workspace Settings -- Server Settings

Set Enable Installer Menu Items in Workspace to YES and restart browser

After restarting browser, check Tools for client installers

Thanks,
Madhusudhan

Thursday, April 9, 2020

ORACLE EPM 11.2 Updates

Oracle EPM suite 11.2 version released and few updates which i captured form System and also from documentation.

First of all while doing installation and configuration, major update is RCU. We need to use RCU before going to configure in all servers. Check out below link for more details.

DRM 61043 - EPMCSS - 00001 - Failed to initialize shared service security instance

DRM 61043 - EPMCSS - 00001 - Failed to initialize shared service security instance

When trying to integrate Shared Services with DRM, We may face this issue, if we miss to configure Foundation Common settings.

Solution:
To avoid above error, we must needs to install Foundation on DRM server and configure common settings to get DRM server host name gets updated to Shared Services Registry.

Thanks,
Madhusudhan

FDMEE service automatically stops when trying to start

Generally we will increase heap size of web application depends on Server Memory (RAM).

If we increase java heap size more than 4 GB for xms value, FDMEE not able to take memory and stopping automatically.

So, we tried to decrease xms to 4 GB, xmx to 16 GB as we have sevrer memory 32 GB in Total.

Thanks,
Madhusudhan

Tuesday, March 17, 2020

Commands which will be useful for Administrator tasks

First of all, whenever we work on Hyperion infra tasks, some times we may get requirement to work on Database. For example, while doing configuration, or migrations, or for any tasks relared to. So, one my colleague and friend, suggested list of tasks, queries, and how to check them on SQL Server Database.

Speacial Thanks to Vijay Darshanala, MSSQL DBA
https://www.linkedin.com/in/vijay-darshanala-12621673/

SQL Commands:

To check Snapshot and Read_committed status:
select name
snapshot_isolation_state
, snapshot_isolation_state_desc
, is_read_committed_snapshot_on
, recovery_model
, recovery_model_desc
, collation_name
from sys.databases;

To Create view as table:

SELECT *
INTO NewTableName
FROM TableOrViewName

To know SQL Version
select @@version

To find the backup percentage and estimated time:
SELECT
session_id,
start_time,
status,
command,
percent_complete,
estimated_completion_time,
estimated_completion_time /60/1000 as estimate_completion_minutes,
--(select convert(varchar(5), getdate(),8)),
DATEADD(n,(estimated_completion_time /60/1000),GETDATE()) as estimated_completion_time
FROM sys.dm_exec_requests where command = 'BACKUP DATABASE' OR command = 'RESTORE DATABASE'

Table backup:

Select * INTO BackUP_TABLE from Table_TO_BE_BACKUP;

Backup Process:

You can take backup with compression backup option, so in this way back file will come in compression mode, size will be less comparatively normal backup.

Go to Tasks -> Backup -> Options -> Set Backup Compression option to Compression backup from default.