Essbase Substitution Variables in Essbase SQL Load Rules

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

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


@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

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