Wednesday, July 18, 2018

Hyperion Logs Location

Hi ,

Please find the logs location of every Hyperion product
  • Planning_WebApp.log (Post 11.1.2.3x versions only)
  • Planning0.log
  • HyS9Planning-sysout.log and HyS9Planning-syserr.log (Windows only)
  • Start-Planning0.log (Unix only)
  • Planning_Adf.log (Post 11.1.2.2x versions only)
  • Essbase Application log (<appname>.log)
  • SharedServices_SecurityClient.log
  • SharedServices_LCM.log
  • Migration logs (LCM_timestamp.log)
Additional Data Files:
  • Essbase Server log (Essbase.log)
The engineer is likely to request other files and data which RDA will automatically collect in one script execution, for example:
  • Hyperion Planning version information + any patches applied
  • Host platform details such as OS version, memory, cpu and disk capacity/usage, network settings
File Locations:
11.1.2.1.x:
  • HyS9Planning-sysout.log and HyS9Planning-syserr.log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\services
  • Planning0.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • Start-Planning0.log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\starter
  • Essbase Application log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\essbase\essbase\app\<appname>
  • Essbase Server log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\essbase\essbase
  • SharedServices_SecurityClient.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • SharedServices_LCM.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\FoundationServices0\logs
  • Migration logs (LCM_timestamp.log): MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\migration
11.1.2.2.x:
  • HyS9Planning-sysout.log and HyS9Planning-syserr.log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\services
  • Planning0.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • Start-Planning0.log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\starter
  • Planning_Adf.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • Essbase Application log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\essbase\essbase\app\<appname>
  • Essbase Server log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\essbase\essbase
  • SharedServices_SecurityClient.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • SharedServices_LCM.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\FoundationServices0\logs
  • Migration logs (LCM_timestamp.log): MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\migration
11.1.2.3.X & 11.1.2.4.x:
  • Planning_WebApp.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • HyS9Planning-sysout.log and HyS9Planning-syserr.log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\services
  • Planning0.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • Start-Planning0.log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\starter
  • Planning_Adf.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • Essbase Application log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\essbase\essbase\app\<appname>
  • Essbase Server log: MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\essbase\essbase
  • SharedServices_SecurityClient.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\Planning0\logs
  • SharedServices_LCM.log: MIDDLEWARE_HOME\user_projects\domains\EPMSystem\servers\FoundationServices0\logs
  • Migration logs (LCM_timestamp.log): MIDDLEWARE_HOME\user_projects\epmsystem1\diagnostics\logs\migration

Wednesday, June 20, 2018

Designing HFR Reports

Hi,

We have two ways to build our HFR 11.1.2.4 reports

From Workspace launch Web reporting studio

From HFR Studio [Which we can Install from Workspace->Tools->Install->HFR Studio

How to check the HFR services from Workspace

Navigate->Administer->Services->RA Services should be in green ball


Tuesday, June 19, 2018

Keepass : Your client server details wallet

Hi,

Today I gonna talk about something a tool which is very important to store your server passwords

Tool Name : Keepass

URL :https://keepass.info/

Download and Install it on your system and store all your passwords in a safe wallet.


Monday, June 18, 2018

Cannot perform Cube View operation

Hi Team,

If you are facing any issue while running the report from Workspace as below please follow the below suggestions

Issue:


please follow the below steps:

1.     1.Connect to FR studio open the  affected Report
2.     2.Highlight the Grid
3.     3.Navigate to Task>Data Query Optimization Settings
4.     4.Uncheck the option for "Essbase Queries use MDX".
5.     5.Click on "OK" tab to Save.

6.     6.Save and run the report



Wednesday, June 13, 2018

Are you going to attempt FCCS Certification?????? This is for you....

Hi,

My suggestion to the folks who are going to attempt Oracle FCCS Certification [1ZO-983]

Please go through this document 1-10 times to understand since we get almost 50-70% of those questions

"https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/agfcc/EPM-INFORMATION-DEVELOPMENT-TEAM-E93973-628A1C2A.pdf "

Certification Code:

1Z0-983 Oracle Financial Consolidation and Close
Cloud Service 2017 Implementation Essentials

Passing Score is 66%

Focus on following concepts

Create a Financial Consolidation and Close application
Create translation rules to override the default translations -
amounts/rates, defaults, logic
Describe sequence of events in consolidation process
Design Cash Flow reporting, FX calculations, and Currency
Translation Adjustments using Movement dimension
Design and set up Account dimension
Design and set up Entity dimension
Design and set up Intercompany dimension
Diagnose data flow of consolidation process and the role of
Consolidation dimension
Explain Currency dimension
Perform administration tasks: predefine system setting
profiles, set up source systems, register target applications,
set up drill through


  Please let me know if you need any information....





Wednesday, February 28, 2018

EPBCS Docs & Videos

Hi Folks,

Please find all the PBCS/EPBCS videos and good documents as I have seen

https://docs.oracle.com/cloud/latest/epm-common/CGSAD/CGSAD.pdf

All PBCS Videos :

https://www.youtube.com/watch?v=a7fpFkF8uS0&list=PLFPF-EEAm1xTrAX7haC3t_8PNhp-1bP4Y


Oracle 1z0-982

Hi All,

I am going to give you all EPBCS documents in this post those who are interested to write E-PBCS certification....


Oracle 1z0-982


Oracle Enterprise Planning and Budgeting Cloud Service 2017 Implementation Essentials




Oracle® CloudGetting Started with Oracle EnterprisePerformance Management Cloud for
Administrators

Documents URL's:

https://docs.oracle.com/cloud/latest/epm-common/CEPMA/using_epmctl.htm#CEPMA-using_pbcs_book_2570 Oracle Cloud, Administering Planning for Oracle Planning and Budgeting Cloud

https://docs.oracle.com/cloud/latest/pbcs_common/EPBCA/common_enable_map_rename_dimensions_104xf0d057d8-03.htm#EPBCA-GUID- 7D681196-86D2-454E-AC4D-727EFD533AB0

https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/other_supported_delimiter_characters_104x085fcea9.htm

https://docs.oracle.com/cloud/latest/epm-common/ERPIA/ERPIA.pdf

https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/understanding_data_maps.htm#PFUSA-f_data_maps_164

https://docs.oracle.com/cloud/latest/pbcs_common/EPBUG/wf_reporting_on_data_104x0254ad2f.htm#EPBUG-GUID-CCDBE3B5-D15E-4E62-834F- A3A6E85B1D47

https://docs.oracle.com/cloud/latest/epm-common/CEPMA/epm_automate_command_ref_general.htm#GUID-5400C490-264F-493A-9EAD- 267AB2A320F1 section-1212-0D8111A4