Hyperion Planning (MOSC)

MOSC Banner

how to judge if a shared member is a descendants of a specified member in business rules

edited Sep 16, 2016 5:00AM in Hyperion Planning (MOSC) 1 commentAnswered ✓

how to judge if a shared member is a descendants of a specified member in business rules? Usually, it's the basic member but not the shared member that was judged in the rule.

the example is as follows:

SET UPDATECALC  OFF;

SET AGGMISSG ON;

fix("CU00","SP200","SP100",&BudYear,"Budget",@RELATIVE("YearTotal",0),

   "I00","P00","CNY",&CurVersion,@share(@relative("YXQC200",0))/*甲公司的共享成员*/)

  "A100201010101020101"

  (  /* 判断甲公司的共享成员是否是XX公司的后代 */

  if(@ISDESC("YXQC200")) 

  /* 主营业务成本  */

  "A100201010101020101"=100;

  endif)

endfix

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