Many times Oracle DBA while working on Windows might need to create environment variables like ORACLE_HOME, ORACLE_SID, and TNS_ADMIN. Here in this post, we will check How to create environment variables in Windows How to create environment variables in Windows Step 1: Log in to the server with a user who has an administrator privileged […]
hyperion
Oracle drm interview questions
Here are the Top Oracle DRM Interview questions Question 1 What is Version? Answer Data Relationship Management organizes sets of related data into versions. It is a collection of all hierarchies. Can be live, or a snapshot of metadata at a certain time. Data within each version is categorized into hierarchies, nodes, and properties. All […]
Oracle Data Relationship Management: Definition, Password , Login
What is Oracle Data Relationship Management? DRM stands for Data Relationship Management. It is a component of the Enterprise performance management Application suite(EPM) It Synchronizes hierarchies, cross-references, and enterprise dimensions across all applications It is a centralized “system of record” to capture and manage changes to critical reference data across enterprise applications It is a […]
How to Stop/Start HFM services
HFM services have different stop/start procedures for various EPM services. Let’s see How to Stop/Start HFM services in VArious EPM versions How to Stop/Start HFM services in 11.1.2.1 to 11.1.2.3 The main processes in this HFM version are HSXServer.exe – Primary HFM process. The process runs on the same machine as the IIS components and […]
How to generate epm registry report and edit it
epmsys_registry utility is used to generate the report and edit it How to generate epm registry report You create the report by running the epmsys_registry utility with no parameters cd /d d:\Oracle\Middleware\user_projects\epm_system1\binepmsys_registry An HTML formatted report is saved to: <Middleware_Home>\user_projects\\epm_system1\diagnostics\reports\deployment_report.html This registry report will contain all the information stored in the registry. How to edit […]
How to generate EPM Deployment Report
The deployment report is a handy new feature added into the epmsys_registry utility that allows you to output a compact collection of the EPM System installation details. It contains below information Logical Web Addresses Application Tier Components EPM Deployment Topology Report EPM Deployment History Report User Directories – SSO Not Enabled Database Connections Data Directories […]