essbase IF (@ISMBR(@IDESCENDANTS

essbase IF (@ISMBR(@IDESCENDANTS( question

Esta pregunta no se respondió.

649268 11-jun-2010 13:47

I have a cross dimension calc script that I need to put in limit for

IF (@ISMBR(@IDESCENDANTS(the member limit)))


example:
FIX ("May")
"Cost"(    
     IF (@ISMBR("jan"))
IF (@ISMBR(@IDESCENDANTS(expense)))
     "Cost" = "janmd"->"All Step"->"Project"->"Jan" * Hrst->"JanTotal";

ENDIF
)
ENDFIX

formula validates but it doesn't computate

If I take out the IF (@ISMBR(@IDESCENDANTS(expense)))
it computates and gives me the result expected.

• 633 Vistas

• Re: essbase IF (@ISMBR(@IDESCENDANTS( question

  

  _RahulS_ 11-jun-2010 14:48 (en respuesta a 649268)

  Hi,
  
  The @ISMBR function returns TRUE if any specified member matches the member being calculated.
  1) A single member, @ISMBR("Florida")
  2) a range of members, @ISMBR("New York" : "Florida")
  3) a discrete list of members may be specified,@ISMBR("Florida","Texas","New Mexico")
  
  BTW, why dont you directly use @ISCHILD, @ISIDESC etc?
  
  Cheers...!!!
  
  Edited by: RahulS on Jun 11, 2010 8:18 PM

  • Reportar abuso
   
  • Me gusta (0)

  • Re: essbase IF (@ISMBR(@IDESCENDANTS( question

    

    649268 27-abr-2011 13:25 (en respuesta a _RahulS_)

    two part answer
    
    FIX (&CurrMth)
    "Cost"(    
         IF (@ISMBR("jan"))
         "Cost" = "Jan hr"->"All Step"->"All Project"->"Jan" * Hours->"Jan Total";
         ELSEIF (@ISMBR("feb"))
    2nd part
    
    "Cost"(
    IF (@ISMBR(@IDESC("Other Projects")))
    IF (@ISMBR("STEP 2") OR @ISMBR("STEP 3") OR @ISMBR("STEP 5") )
    
    IF (@ISMBR("jan"))
    "Cost"= "jan ar" ->"All Step" -> "All Project" * Hours->"Jan Total";    
    ELSEIF (@ISMBR("feb"))
    "Cost"= "feb ar" ->"All Step" -> "All Project" * Hours->"Feb Total";    
    ELSEIF (@ISMBR("mar"))