Hyperion Planning (MOSC)

MOSC Banner

Matching members with aliases

edited Jan 8, 2019 12:32PM in Hyperion Planning (MOSC) 4 commentsAnswered ✓

Hi everyone,

We developed a prototype where months were named as m1, m2, m3, ... m12. Now we have been asked to name months after the usual jan, feb, mar...codes and pass the m1, m2, m3... as aliases to them so jan has the m1 alias, feb is m2,... and so on.

Somewhere into the system dates are being input in the YYYYMMDD format, so we have an account member that takes the part of the date corresponding to the month.

E.g:

StartDate = 20181125  makes StartMonth = 11

StartDate = 20180225  makes StartMonth = 2

And one of our calcs had the following:

@MEMBER(@CONCATENATE("m"

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