Using the Oracle Smartview Planning Admin Extension to update Planning metadata

by

The Oracle Smartview Planning Admin Extension allows you to update Planning application (both Oracle PBCS and On-Premise Classic applications) metadata using Smartview. The SmartView Planning Admin Extension can be downloaded from within the Oracle EPM Workspace. Go to Tools->Install and select ‘Planning Admin Extension’. Download and install this utility. Once the utility is installed, connect to the Planning application using Smartview. Expand the Server and then the application (‘Vision’ in this case). You will notice … Read More

Getting started with Oracle Planning and Budgeting Cloud Service – Oracle PBCS

by

Oracle Planning and Budgeting Cloud Service (Oracle PBCS) is Oracle’s cloud offering for financial planning and budgeting. This post gives an overview of the cloud service covering access, application creation, mobile interface, data management, automation options and service management. Accessing Oracle PBCS Oracle PBCS subscription offers two environments; Test and Production. Each environment has a dedicated URL to access Workspace. When you access Oracle PBCS Workspace, you get a login screen with a field to … Read More

Essbase Substitution Variables in Essbase SQL Load Rules

by

Do you know that you can use Essbase Substitution Variables in Essbase SQL Load rules? For example, you can use the substitution variables in the where clause of a SQL query to fetch only a specific year or month corresponding to the value of the variables. This is a very good feature if you want your SQL data loads to be controlled using the Essbase Substitution variables. Read further to see how this can be … Read More

Smartview netRetryCount and netRetryInterval error

by

When querying databases with high dimensionality using Smartview, users may get the Smartview netRetryCount and netRetryInterval error. The exact text of the error is “The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval” Smartview uses Internet Explorer query and time out settings for connections. Some queries take longer to execute and hence get a time out error. You need to update Internet Explorer registry settings to increase the time out thresholds. The … Read More

Essbase @MOVSUM and @MOVSUMX XRANGEList

by

@MOVSUM and @MOVSUMX functions are handy functions that can used to calculate trailing or forward sums across dimensions. You can benefit from using these functions for calculating rolling sums. Details about @MOVSUMX function from the Oracle tech ref can be found here. Although the tech ref gives a lot of details, I thought it was worth sharing a practical use of this function and something worth noting regarding the time period range used in the … Read More

Essbase ASO dimension build limit & Outline Compaction

by

There is a maximum number of times you can add and delete dimensions in an ASO cube. Each dimension added is tagged with a dimension ID that increments and reaches the ASO dimension build limit. Once you reach this limit, you get errors. For e.g. ESSBASE ASO Error:  “1060190 Cannot Add Dimension – too many dimensions have been created and deleted”. EPMA-ASO Error: Error. Failed to deploy Essbase cube. Caused by: Cannot end stream build. … Read More

View Aliases in EPMA member property grid

by

By default in EPMA when you select a member, the member property grid does not show the aliases. This can be annoying when you want to quickly browse through the member properties and inspect the aliases. Here is an example of how the property grid shows a blank alias.To see the alias you need to double click on the Alias text box and then browse to see the alias. To enable EPMA to show aliases … Read More