How To Purge FDMEE Files


Under FDMEE instance, there is data and outbox directory which is getting bigger (80GB). How do we clean up those directories? What is the standard process? There are some some other files such as .ind and .dat direxctly under FDMEE instance. How do we clean those up?

In-order to purge the FDMEE files, there is an option under “workflow” > Go to > Script Execution > Click on System Maintenance Tasks > there you have the scripts to Purge files.

These scripts run based on the application, you need to select the start and the end period along with the category.

This will help you to purge files.

Maintain Application Folder
======================

The Maintain Application Folder process purges files from the inbox, outbox, and data folders directory. Oracle Hyperion Financial Data Quality Management, Enterprise Edition accepts a separate Days to Keep parameter for each of the folders. If the value is not specified for a specific folder, FDMEE skips the folder.

In addition, FDMEE checks the inbox and outbox sub-directories under the respective folders and deletes any files. In the data, FDMEE skips the scripts directory because it holds customer scripts.

Maintain Process Table

This process maintains the following execution tables:

AIF_PROCESSES

  AIF_PROCESS_DETAILS

  AIF_PROCESS_LOGS

  AIF_PROCESS_PARAMETERS

  AIF_PROCESS_PERIODS

  AIF_PROCESS_STEPS

  AIF_BAL_RULE_LOADS

  AIF_BAL_RULE_LOAD_PARAMS

  AIF_BATCH_JOBS

  AIF_BATCH_LOAD_AUDIT

  AIF_TEMP

It accepts the number of days to keep as a parameter.

Thanks,

~KKT~

Advertisements

FDMEE Runs Out of Resources


Dears,

From last month we noticed that FDMEE software has been going down multiple times a day. Below error message we are receiving in the logs

Error Message: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool aif_datasource to allocate to applications, please increase the size of the pool and retry..

Increase the connection pool for jdbc source (aif-source) from default 120 to 200 then 300

so we check and Currently the Maximum JVM heap Size is set to a large value, but the minimum JVM heap Size does not match the Max. Follow below steps to update.

A) Update the Min and Max JVM heap Sizes to Match each other (xms 5120 from xms 128 as an example to increase to 5 GB)

Start > Run > RegEdit

HKEY_LOCAL_MACHINE > Software > Hyperion Solutions > ERPintegrator0 > HyS9AIFWeb_epmsystem1

Locate the JVMOption value for -Xmsxxxm

Locate the JVMOption value for -Xmx5120m

Make sure the two match

B) Verify that the AIF_DataSource JDBC Connection Pool Max is set to a large enough value (depends on number of users)

C Verify that the ODIMASTER JDBC Connection Pool Max is set to the same value as the AIF_Datasource JDC Connection Pool

D) Recycle the FDMEE Web Application

Thanks,

~KKT~

Essbase Cloud – Importing and Exporting Bulk Users


Importing and Exporting Bulk Users

In Creating Users and Assigning Roles, you learned about creating a user and assigning a role.

Now you’ll learn how to run bulk imports and exports of files with multiple users and roles.

Importing a Bulk File of Users and Roles

  1. Create a comma-separated Excel file (saved as .csv) that contains the user ID, first and last names (optional), email address (optional), password (optional) and role type (User, Power User, or Service Administrator).
  2. Log into Oracle Analytics Cloud – Essbase as a Service Administrator, server_admin.
  3. On the Applications home page, click Security Image of the Security icon..
  4. On the Security page, click Import.
  5. Browse to the local .csv file created in Step 1, and click Import.
  6. Click Download Logs if you want to view the log file for results of the import. Otherwise, click Cancel.
  7. Click Search to refresh the page and view the users and roles imported to the cloud service from the .csv file.

Exporting Bulk Users and Roles

  1. On the Security page, on the Users tab, click Export.
  2. Save the .csv file to a local directory.
  3. You can open the .csv file in Excel to view the exported user data.

Thanks,

~KKT~

Essbase Cloud – Creating Users and Assigning Roles


Creating Users and Assigning Roles

In this task, you’ll create a user and assign one of the predefined Oracle Analytics Cloud – Essbase roles to that user.

Predefined User-Level Role Description
Service Administrator Can administer the entire cloud service instance, including backing up, creating and deleting applications, provisioning users, and running jobs (such as calculations and data loads).
Power User Can create applications and cubes, and grant access to users to perform actions on those cubes.
User Can access and perform actions on cubes for which access has been granted.
  1. Log into Oracle Analytics Cloud – Essbase using the default Oracle Analytics Cloud administrative user, admin.
  2. On the Applications home page, without selecting an application or cube, click Security Image of the Security icon..
  3. On the Users Image of the Users icon. tab, click Create to add and provision Oracle Analytics Cloud – Essbase users.
  4. On the New User dialog box, provide the following information:
    1. Enter a user ID for a Service Administrator role: server_admin.
    2. Enter the user’s name.
    3. Enter the user’s e-mail address.
    4. Create and confirm a password.
    5. Select the role Service Administrator.
  5. Click Create. The new Service Administrator user is added to the list of users.

Thanks,

~KKT~

OAC Essbase – Security Provisioning Users


Provisioning Users

If you’re a Service Administrator or Power User, you can provision users and groups for applications that you created.

Note:

  • Users and groups are created and managed on the Security page of the cloud service, as described here.
  • You can easily import or export user and group data files using the corresponding buttons.
  • You can’t create users and groups with the same name.

Creating a User

  1. On the Applications home page, without selecting an application or cube, click Security Image of the Security icon..
  2. On the Users Image of the Users tab icon. tab, click Create to add a user.
  3. On the New User dialog box, enter the IDNameEmail, and Password for the user, and then select a Role.
  4. Click Create.

Editing a User

  1. On the Applications home page, without selecting an application or cube, click Security Image of the Security icon..
  2. On the Users Image of the Users icon. tab, select a user row, click Actions Image of the Actions icon, and then select Edit.
  3. On the Edit User dialog box, modify the user details and click Submit.

Deleting a User

  1. On the Applications home page, without selecting an application or cube, click Security Image of the Security icon..
  2. On the Users Image of the Users icon. tab, select a user row, click Actions Image of the Actions icon, and then select Delete.
  3. On the Delete User dialog box, click Yes if you want to confirm the user deletion.

Creating a Group

  1. On the Applications home page, without selecting an application or cube, click Security Image of the Security icon. .
  2. On the Groups Image of the Groups icon. tab, click Create.
  3. On the New Group dialog box, enter the Name and Description for the group, and then select a Role.
  4. Click Create.

Editing a Group

  1. On the Applications home page, without selecting an application or cube, click Security Image of the Security icon..
  2. On the Groups Image of the Groups icon. tab, select a group row, click Actions Image of the Actions icon, and then select Edit.
  3. On the Edit Group dialog box, modify the group details and click Submit.

    The group’s details are modified.

    Note:

    On the Parent Groups tab, the parent of a group can be selected from the available groups that are listed.

Deleting a Group

  1. On the Applications home page, without selecting an application or cube, click Security Image of the Security icon..
  2. On the Groups Image of the Groups icon. tab, select a row for a group, click Actions Image of the Actions icon, and then select Delete.
  3. On the Delete Group dialog box, click Yes if you want to confirm the group deletion.

Thanks,

~KKT~

OAC Essbase – Downloading Server and Application Logs


As a Service Administrator, you can download all logs (server and application). You can download the latest log as well as rolled over logs.

  1. On the Applications home page, click Admin admin icon image without selecting an application.
  2. Expand Server and Applications to see the available logs.
  3. Click Download download icon image and select Download Latest or Download All.

You can download these kinds of server logs:

  • Managed Server: Warnings and error messages regarding Weblogic issues
  • Console Output: Managed server run-time exceptions and messages
  • Platform: User interface
  • Agent
  • Application Provider Service

As an Application Manager, you can download applications logs. You can download the latest log, as well as rolled over logs.

  1. On the Applications home page, select an application, then click Admin admin icon image.
  2. Click Logs image of logs tab.
  3. Select Latest or All, then click Download download icon image.

Thanks,

~KKT~

OAC-Essbase Starting, Stopping and Restarting Services


You can start, stop and restart service from the Oracle Analytics Cloud dashboard.

1. On the Oracle Analytics Cloud dashboard, select Manage the service for service
you want to start, stop or restart.

2. Select the action you want to perform.

3. Select Start to start the service.

4. Select Stop to stop the service.

5. Select Restart to restart the service.

Alternatively, click the icon for Start Service, Stop Service, or Restart Service on
the Overview pane.

Thanks,

~KKT~

OAC-Essbase: How To Find Out the Volume of Data in Any Essbase Application Database


Find out the volume of data in a particular Essbase database.

There are a few ways to get this information.

1. SSH onto the server and check the /u01/latency/app/appname/dbame/cube directory.

ssh -i <private key> opc@ipaddress
sudo -su oracle (Change to the Oracle user)
cd /u01/latency/app/appname/dbame/cube
ls -l (to list all the page and index files with their sizes)

2. Run MaxL on the server, /u01/data/domains/esscs/esstools/bin/startMAXL.sh and run the command:

query database appname.dbname list all file information; 

(or replace all with data or index)

3. Create a MaxL script in the /u01/latency/app/appname/dbame directory (not the cube or database directory) and have it output to a file, for example:

spool on to ‘/u01/latency/app/appname/dbame/output.txt’;
query database appname.dbname list all file information;
spool off;
logout;
exit;

Use the CLI tool to run the MaxL script:

Esscs login –user username –password password –url https://IPaddress/essbase
Esscs script –application appname –db dbname –script scriptname.msh

Then in the UI, select the database, go to Files and the output file should be listed that you can open/download

Thanks,

~KKT~

OAC-Essbase – Using The ‘esscs’ Command Line Utility (CLI)


The Command-line tool is for the exporting the outline of a cube into a formatted Excel workbook template and, optionally, exporting the cube data to a text file.

Downloading and Using the Command-Line Interface

1. If it is not already installed, download and install Java SE Development Kit 8 from Oracle Technology Network.

2. Set the JAVA_HOME environment variable on your system to point to the JDK installation folder. For example, set it to C:\Program Files\Java\jdk1.8.0_45.

3. In the Essbase UI on the home page, click Utilities .

4. On the Utilities page, click Download next to the utility labeled Command Line Tool.

5. Save the export utility, which is named cli.zip, to a local drive.

6. Uncompress cli.zip, and see the extracted files under the cli folder.

7. Login to the OAC Essbase Server:

• Windows: Run esscs.bat
• UNIX: Run esscs.sh

esscs login -user <username> -password <password>-url http://<hostIP>/essbase

 

To display help for all commands, enter:

esscs -h

The following commands are available:

  • calc
  • clear
  • dataload
  • deletefile
  • deploy
  • dimbuild
  • download
  • lcmexport
  • lcmimport
  • listapp
  • listdb
  • listfiles
  • listvariables
  • login
  • logout
  • script
  • setpassword
  • ssl
  • upload
  • version

For specific information on using these commands, use:

esscs <commandname> –help
Thanks,
~KKT~

OBIEE 12c: How To Change The Essbase JAgent Port


This document provides the steps to change the Essbase JAgent port in an OBIEE 12c environment

Unfortunately The System Administration Guide Changing Essbase Ports in Oracle Business Intelligence incorrectly lists OBIEE 11g steps.
Unpublished documentation bug 26801849 has been filed to correct the steps.

This port setting is defined in the essbase.cfg using the parameter AGENTPORT
The default value for this AGENTPORT is 9799, to change it please follow the steps below:

  1. Backup and edit the file on PROD environment:

    [DOMAIN_HOME]\config\fmwconfig\biconfig\essbase\essbase.cfg

  2. Change the line:

    AGENTPORT 9799

    To:

    AGENTPORT 9779 (i.e. – any free port of your choice)

  3. Save the file.
  4. Restart the OBIEE servers (stop.sh then start.sh)

Thanks,

~KKT~