Tuesday, August 9, 2022

EPM CLOUD - FCCS / EPBCS / PBCS - NEW SAVE AS OPTION FOR JOBS

The new "Save As" option for jobs enables you to create a duplicate of an existing job, and then update it to avoid starting over making selections each time you create a new job.

"Save As" is supported for the Export Data, Import Data, Export Metadata, Import Metadata, Refresh Database, Clear Cube, and Import Exchange Rates job types.

To duplicate a job, click Application, then Overview, click Actions, and then select one of the following actions:

Export Data

Import Data

Export Metadata

Import Metadata

Refresh Database

Clear Cube

Import Exchange Rates

On the listing page, click the ellipses icon (...) in the Actions column next to the job that you want to duplicate. 

Click Save As, enter a name for the new job, and then click OK. 

After the duplicate job is created, you can then open the job and update it. 

The error file for the duplicate job will automatically use the new job name as a prefix.

 

DISPLAY MEMBER NAMES AND ALIASES IN SEPARATE COLUMNS IN SMART VIEW AD HOC GRIDS

A new Member display option in Oracle Smart View for Office, Member Name and Alias, allows you to display both the member names and their aliases in separate columns on row dimensions in ad hoc grids.

The Member Name and Alias display option allows users to see the member name and the alias side by side during adhoc zoom interactions within the grid. 


In Smart View, place an ad hoc grid on a worksheet. You may have more than one row dimension in the grid.

In the Smart View ribbon, select Options.

In the Member Options tab, Member Name Display, select Member Name and Alias, then click OK.

In either the Smart View ribbon or the provider Ad Hoc ribbon, click Refresh.

For row members, both member names and their corresponding aliases are displayed in the ad hoc grid.


STEPS TO ENABLE

To enable the Member Name and Alias option for Smart View users working with ad hoc grids, the business process application option, Smart View Ad Hoc Behavior, must be set to Standard.

All new and recreated applications are automatically set to Standard.

For existing and migrated applications, to set the application option, Smart View Ad Hoc Behavior, to Standard:


Click Application, and then click Settings.

For the Smart View Ad Hoc Behavior option, select Standard.

Click Save.


NOTE

The Member Name and Alias option is supported with:

Standard-mode applications only

Smart View 22.100 and later

Other posts

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...