How to restrict users from viewing load files from other locations in FDMEE

Create two locations in the names (example) "ForlocationA" and "ForlocationB"
Created two new users "USER A" and "USER B"
In Data Management enable "Location security" under Setup > Security settings
Click on "Maintain User groups" with prefix A and suffix K (anything)

Now new groups "A_ForlocationA_K" and A_ForlocationB_K" will be created

Assign those two groups with either Create Integration, Run Integration or any Intermediate roles.

Then in Shared services, assign USER A as a member of Group "A_ForlocationA_K"
Then in Shared services, assign user B as a member of Group "A_ForlocationB_K"

Then grant both the users USERA and USERB with the roles Create Integration, Run Integration roles

Then login to the workspace with userA - navigate to select Inbox and you will be able to see the folder ForlocationA alone
Then login in to the workspace with userB - navigate to select Inbox and you will be able to see the folder ForlocationB alone

You will not be able to see other locations created by other users when that respective user is logged in,

Where to find the EPM Logs and its location - Hyperion

EPM Registry Report

a. On Foundation server go to the location \Oracle\Middleware\user_projects\epmsystem1\bin
b. Run the batch epmsys_registry.bat.
c. This will generate the Registry.html file under the location \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports

EPM Deployment report

a. On Foundation server go to the location \Oracle\Middleware\user_projects\epmsystem1\bin from the COMMAND PROMPT.
b. Run the command 'epmsys_registry.bat report deployment'
c. This will generate the deployment_report.html file under the location \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports

Ziplogs

a. On the Server go to the location \Oracle\Middleware\user_projects\epmsystem1\bin.
b. Run ZipLogs.bat
c. The output of this is generated in \Oracle\Middleware\user_projects\epmsystem1\diagnostics\ziplogs\EPM_logs__11.1.2.x.0.zip

Submitting an UDR from EPM cloud Environment along with snapshot to Oracle Support

From the Simplified Interface - open Setting and Actions by clicking your username (displayed at the right top corner of the screen) -> Select Provide Feedback -> Enter a brief description -> Click the Submit button -> Click the Confirm Application Snapshot Submission > ON ->Click on Submit button again.

How to restart the services of an EPM Cloud Environment

How to restart the services of an EPM Cloud Environment 

Using the EPM Automate feature users can do a restart of their EPM Cloud environment.

The command to be used is as follows,

Ex: epmautomate resetservice "Users experience unacceptably slow connections"

Working with EPM Automate

1. Download the latest version of EPM Automate
    Login to your EPM Cloud Service
    Tools -> Install -> EPM Automate

2. Install EPM Automate
    Run the EPM Automate.exe downloaded in step 1

3. Use EPM Automate using a command prompt

    - Open Command Prompt
    - Navigate to the install Location

Example: CD :\Oracle\"EPM Automate"

- Login to EPM Automate

epmautomate login / identitydomain

Example: epmautomate login https://.pbcs.us2.oraclecloud.com mydomain

- Run reset Service Command

epmautomate resetservice "Users experience unacceptably slow connections"

Is it Possible to Disable EPM Cloud Passwords from Expiring

This is not possible as it is a violation of password policies,

The only workaround is to enable SSO with their own Identity Provider (IdP) and customer can manage their own password policies.

Please see the documentation for the same below :
https://docs.oracle.com/en/cloud/paas/process-cloud/cprcw/configuring-federated-sso-and-authentication.html

An Enhancement was raised with regard to this and it was rejected.

How is the data size calculated for a EPM Cloud service instance?

The total size of data used by your EPM Cloud service instance is the sum of the following:

• Application data stored in Essbase
• Artifact Snapshot created by the daily maintenance window
• All snapshots that you have exported via EPM Automate or the Migration user interface
• All snapshots that you have uploaded via EPM Automate or the Migration user interface
• All data files that you have uploaded via EPM Automate or the FDMEE user interface

How to overcome Blank page issue during Drill-through via Smartview in EPM Cloud

In EPM Cloud, (PBCS,EPBCS) users might face an issue while doing a drill-through to data management or drill-through to source values.
Users might get a Blank page during the process.

The Smart View extension (add-in) for the browser would have not been installed.

To install the add-ins, refer the steps below

Chrome: 

Download the Smart View for Office extension from the Chrome web store.

Firefox:

Information about the Firefox add-in -
https://docs.oracle.com/applications/smartview/720/SVNST/firefox_extension_100x0867c8ee.htm#SVNST-GUID-DA412821-E7CD-40E4-9CA0-9739D8CAC0D8

For, IE11 - The following settings changes have to be completed -


Go to Tools > Internet Options > General > Tabs

Choose Open links from other programs : The current tab or window

New and missing features in Cloud Data Management in comparison to FDMEE on-premise

New and missing features in Cloud Data Management in comparison to FDMEE on-premise

Significance of Data Management in Cloud

Significance of Data Management in Cloud 

Cloud Data Management is intended to allow an organization to adopt a pure Cloud solution for Oracle EPM deployments.

• Cloud Data Management is a module within the Oracle EPM Cloud Services.
• It is built using the same code line as on-premises FDMEE.
• Cloud Data Management can integrate flat files.
• It includes all the on-premises FDMEE transformation capabilities including SQL mapping which can accommodate complex transformations.
• It includes the prebuilt logic to natively load data to each of the Oracle EPM Cloud
• Service offerings.
• Cloud Data Management can integrate with other Oracle Cloud Service offerings
• including the ability to source data from and load data back to Fusion G/L Cloud.
• As well, it can source data from other Oracle EPM Cloud Services.