Hyperion Planning (MOSC)

MOSC Banner

Xref with Smartlist member

edited Aug 12, 2014 5:03AM in Hyperion Planning (MOSC) 3 commentsAnswered

Hi to all,

in Planninig Clout application, i've a smartlist in Plan 1 with elements named like Plan3 dimension members.

For example: in Plan 1 i've this smart list:

(id: 1) SL1

(id 2) SL2

(id 3) SL3

And in Plan3 i've this dimension:

Listino

     -TOT_LISTINO

          --SM1

          --SM2

          --SM3

In plan 1 i've to reach data from Plan 3 using @XREF function.

If I try with this: P0_Listino = @xref(Plan3,@name([[Prova_Smart_List.SL1]]),FY14,V_I_TOTALE,NO_TARGET,NO_TIPO_OFFERTA); essbase read the value "1" (that is the Id of smart list's SL1 member) and calculation manager give an error.

If I try with this:

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