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!