Hyperion Essbase (MOSC)

MOSC Banner

Essbase Studio adding shared member with Formula

edited Sep 29, 2016 5:00AM in Hyperion Essbase (MOSC) 1 commentAnswered

Gurus,

Trying to figure out how to avoid a false error in Essbase studio as it builds an ASO cube. The issue in a nutshell is that it is trying to insert a formula to a shared member. The cube builds successfully and the outline reflects the correct changes. But would like to avoid error message altogether. Any advice is greatly appreciated.

Error adding formula (IIF(IS(Currencies.CurrentMember,[USD]),((([XXXXX],[USD])/([YYYYY],[Units]))/12),Missing)) to member Net_Sales_RPU (3322)

"RIF_RPU_Proxy"    "Net_Sales_RPU"    "+"    ""    "IIF(IS(Currencies.CurrentMember,[USD]),((([XXXXX],[USD])/([YYYYYY],[Units]))/12),Missing)"    "2"    ""    ""    ""    ""    ""    ""    ""    ""    ""    ""    ""    ""    ""    "

The outline looks like this

Tagged:

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