Hyperion Essbase (MOSC)

MOSC Banner

Smart View and HsGetVariable function doesn't work properly when Substitution Variables use Qotation

edited Nov 30, 2012 2:53AM in Hyperion Essbase (MOSC) 2 commentsAnswered
Hi,

I just downloaded Smart View v11.1.2.2.300 (per a post I read here in the community).  If I use the HsGetVariable function and the SV has quotation marks because of spaces, the function only works if it's in the far right column.  SV that don't use quotation marks work fine.  For example, I use =HsGetVariable("HSACTIVE","HBMonthlyPlan") (HBMonthlyPlan = "Plan as of Dec") in a column that is NOT on the far right, and refresh the grid, the correct SV replaces the function, however, the dimension the function was used on (Scenario) in this case, is added to the last column.  If I

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center