Amit Sahasrabudhe

New Features in Upcoming Oracle PBCS August Release v15.08

by

Given below are brief details of some of the new features/updates in Oracle Budgeting and Planning Cloud Service Oracle PBCS August Release v15.08 Announcements: New Financial Reporting Studio Release v 11.1.2.4.400. You would need to uninstall the current version and then install the new release. New Version of EPM Automate Utility – This version supports password encryption and file uploads to Data Management folders. New SmartView Version Release v 11.1.2.5.500. Support for Internet Explorer in … 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 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