Hyperion Planning (MOSC)

MOSC Banner

Issue with XRef dynamic Member formula on Smartlist Account Member

edited Mar 16, 2020 1:46PM in Hyperion Planning (MOSC) 2 commentsAnswered

Hi All,

I am using Xref function in Dynamic member formula on Account member called "Status_Consol".

"MS_None"->"Budget_Consol"->"STATUS_Consol" = @XREF("_RevCube_","STATUS","1","Budget");

"MS_None" belongs to the dimension that exists only in Target Plan Type and "1" belongs to the dimension which belongs to only source Plan type Budget Maps to "Budget _Consol" and Status Maps to "Status_Consol" All the other Dimensions are same in both Source and Target Plan Types. above mentioned Dynamic Member Formula is on Member "STATUS_Consol" .

Status and "Srtatus_Consol" are both Smartlist type account members and both use same smart list also called status.

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