Thursday, February 11, 2016

SmartView : #NoConnection Message



A client of mine was recently using the SmartView function "HsGetValue" but kept getting a #NoConnection message instead of data.

Here's one way around that issue:


  • Goto SmartView ribbon and choose "Panel":



Tuesday, January 12, 2016

Essbase : Multiple SQL Data Loads in Parallel to Aggregate Storage Databases

Most of the time, loading Essbase data from SQL Server  in serial mode works just fine:

alter database EssApp.EssDb initialize load_buffer with buffer_id 1;

import database EssApp.EssDb data
connect as SQLUser identified by SQLPswd
using server rules_file   'Load.rul' to load_buffer with buffer_id 1
on error write to 'errorfile.err';

import database ASOsamp.Sample data from load_buffer with buffer_id 1;

But if you have a lot of SQL data loads that take a long time, you might run into complaints from your client to speed of the data load process.  Well, your in luck!

Monday, December 21, 2015

SmartView / Essbase Error 1051021

This will be a quick post on a common SmartView / Essbase error message that comes to me from my clients:

"What does this error message mean?"

Cannot set active application/cube. Essbase Error(1051021): You have been logged out due to inactivity or explicitly by the administrator.


Either there was too much time between your retrieves that SmartView automatically logged you out of Essbase or the Administrator has taken the cube offline for some reason.  But don't worry, there is an easy solution:

Wednesday, December 16, 2015

HFM Extended Analytics 101

One of my clients asked me to give them a quick write up of how Extended Analytics works in HFM since they've never used it before but are looking to explore more possibilities going forward.

Normal data extracts from HFM are limited in the point of view you get to select for the data being extracted.  You are limited to select on 6 of the 12 dimensions the remainder are defaulted, you can only select the following dimensions:

  • Year
  • Period
  • Entity
  • Account
  • Scenario
  • View

The remainder of the dimensions are defaulted for you: 
  • ICP - Base ICP
  • C1 - Base C1