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

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:

Essbase Retrieval Performance with Attributes

So everyone knows that Attributes can be an awesome feature to add to Essbase cube.  I use them all the time.   A primary example would be your Customer dimension in Essbase.  It's a 'stored' dimension, but you need to include many facets of the the customer...like Country/State, Size, Sales Rep, etc.

Migrate from Essbase Excel Addin to SmartView

I am long time Essbase guy that was a big supporter of the Essbase Excel Add-in, but as you know, SmartView is the way of the future when it comes to Excel and Essbase.  Here are some Pros and Cons to migrating to SmartView:

Pros:

SmartView is gone from Excel!!

I get this a lot from my clients, "SmartView is missing from Excel, please help!!"

Actually, its not missing, its just disabled.  Usually, if  Excel crashes for some reason (like a long retrieve or run out of memory), Excel will blame SmartView and disable the add-in.  Have no fear, you can enable SmartView very easily.

In Excel 2010 (works similarly for other version of Excel), follow these steps: