Hyperion Essbase (MOSC)

MOSC Banner

Glueing strings together for dynamic variable selection

edited Jun 4, 2013 8:51AM in Hyperion Essbase (MOSC) 4 commentsAnswered
I'm trying to glue two values together using concatenate, but the function doesn't seem to work for what i'm doing. It returns error code "1200374:  invalid expression return type"

Here is an example: MonthInt returns the number 1 for Jan, 2 for Feb etc.
:
VAR vBaseHours;
VAR vBaseHours1;
VAR Month;

Months_number(

Month = MonthInt;

vBaseHours = 3;

vBaseHours1 = vBaseHours + "Days in Month";

@CONCATENATE(@SUBSTRING(SUBSTRING("&Month", 0));


)
ENDFIX
:
Both @Name and @Substring are suppose to return strings as values, as I interpret the documentation.

Thank you!

Patrick

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