This discussion is archived
9 Replies Latest reply: Aug 10, 2007 11:03 AM by 3004 RSS

I really need help

3004 Newbie
Currently Being Moderated
<p>Hi</p><p> </p><p>I already was replied about the maxrange and maxsrange functionsbut i still have a real problem:</p><p> </p><p>first this is the shema of my outline:</p><p> </p><p>-Measures (Accounts Member)</p><p>|___ Salary</p><p>|___ MaxSalary</p><p> </p><p>-PERIOD (Time Member)</p><p>|___ M01 (Alias January)</p><p>|___ M02 (Alias February)</p><p>.</p><p>.</p><p>|___M12 (Alias December)</p><p> </p><p>-YEAR</p><p>|___2005</p><p>|___2006</p><p>|___2007</p><p> </p><p>-SEX</p><p>|___M</p><p>|_______Worker1</p><p>|_______Worker2</p><p>|___F</p><p>|_______Worker3</p><p> </p><p> </p><p>I load and calculate data for the measure Salary.</p><p> </p><p>When i wanted to add a measure MaxSalary, my problems began toappear:</p><p>I put this Formula in properties of the measure MaxSalary:</p><p> </p><p>IF (@CURLEV ("SEX")>0)</p><p>         @MAXSRANGE(skipboth,MaxSalary,@CHILDREN(@CURRMBR("SEX")));</p><p>ELSE</p><p>       Salary;</p><p>ENDIF</p><p> </p><p>every time i have the same value for Salary and MaxSalary acrossfor example (M, 2007 and M01): the sum of salaries.</p><p>So my question, is the formula correct? Putting it on MaxSalaryFormula is correct? if yes, is there other thing to add to resolvemy problem?</p><p> </p><p>Thank u very much for your help, i really need it.</p>
  • 1. I really need help
    3004 Newbie
    Currently Being Moderated
    <p>Formula looks ok.</p><p> </p><p>Couple of things you could try.  </p><p> </p><p>1) Make the MaxSalary member dynamic calc</p><p>2) Calculate your Measures dimension last</p><p>e.g. Something like this?</p><p> </p><p>calc dim("Period","Year","Sex");<br>Calc dim ("Measures");</p><p> </p><p>I would recommend making these changes in test first</p>
  • 2. I really need help
    3004 Newbie
    Currently Being Moderated
    OuffI really dont know what i have to say to thank you.Really you saved me.It is maybe very simple for you, but it is very important to me.Effectively: i just replaced "Store data" by "Dynamic Calc"Thank you very mych.
  • 3. I really need help
    3004 Newbie
    Currently Being Moderated
    <p>After i changed "Store data" to "dynamiccalc". MaxSalary is correctly calculated for children of"SEX", but for "SEX" itself, i have a blankwhen retrieving on excel. I tried many updates for formulalike:</p><p> </p><p>@CALCMODE (BOTTOMUP);</p><p>IF (@CURLEV ("SEX")==1)</p><p>    @MAXSRANGE(skipboth,Salary,@CHILDREN(@CURRMBR("SEX")));</p><p>ELSEIF (@CURLEV ("SEX")==2)</p><p>    @MAXSRANGE(skipboth,"MaxSalary",@CHILDREN(@CURRMBR("SEX")));</p><p>ELSE</p><p>    Salary;</p><p>ENDIF</p><p> </p><p>another try:</p><p> </p><p>IF (@CURLEV ("SEX")==1)</p><p>    @MAXSRANGE(skipboth,Salary,@CHILDREN(@CURRMBR("SEX")));</p><p>ELSEIF (@CURLEV ("SEX")==2)</p><p>    @MAXSRANGE(skipboth,Salary,@LEVMBRS("SEX", 0))</p><p>ELSE</p><p>    Salary;</p><p>ENDIF</p><p> </p><p>but all that does not work<img src="i/expressions/face-icon-small-sad.gif" border="0"></p>
  • 4. I really need help
    3004 Newbie
    Currently Being Moderated
    Have you tried turning on Two-pass calc for that member?
  • 5. I really need help
    3004 Newbie
    Currently Being Moderated
    Yes i tried a two-pass on MaxSalary.
  • 6. I really need help
    3004 Newbie
    Currently Being Moderated
    <p>I tried also that but it does not work, he dont like twomaxsrange at the same time <img src="i/expressions/face-icon-small-sad.gif" border="0"></p><p>IF (@CURLEV ("SEX")==1)</p><p>    @MAXSRANGE(skipboth,Salary,@CHILDREN(@CURRMBR("SEX")));</p><p>ELSEIF (@CURLEV ("SEX")==2)</p><p>    @MAX(@MAXSRANGE(skipboth,"MaxSalary",@CHILDREN(@CURRMBR("M"))),@MAXSRANGE(skipboth,"MaxSalary",@CHILDREN(@CURRMBR("F"))));</p><p>ELSE</p><p>    Salary;</p><p>ENDIF</p>
  • 7. I really need help
    3004 Newbie
    Currently Being Moderated
    Just for interested, this example helped me to understand many things about essbase:I discover that if you mark some measure as dynamic calc, if it has not enough cache and lockblock, when retrieving, you will just get a blank, not #Missing value or 0 , but blank!!!So, after 2 weeks, i discover that i just was blocked by this case.Guess, how i discovered it, completely by a chance, i tried to change that measure to "Store data" and in that case, calculation failed because of less of cache and lockblock as i said!!!
  • 8. I really need help
    3004 Newbie
    Currently Being Moderated
    <p>Check your add-in options, on the global tab make sure thatDisplay Messages has Errors selected.  I think you will findthat the Dynamic Calc processor error will appear.</p>
  • 9. I really need help
    3004 Newbie
    Currently Being Moderated
    <p><blockquote>quote:<br><hr><i>Originally posted by: <b>abewinfield</b></i> Check youradd-in options, on the global tab make sure that Display Messageshas Errors selected.  I think you will find that the DynamicCalc processor error will appear.</p><p><hr></blockquote></p><p> </p><p>Very nice <img src= "http://dev.hyperion.com/discussion/i/ratingicons/thumbsup.gif"border="0" alt="Thumbs Up"></p><p>I did not know that</p><p>thank you very much</p>