This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Nov 17, 2010 11:16 PM by 815926 RSS

Essbase XREF Freezing problem

tarum Newbie
Currently Being Moderated
I have one planning application and two databases. When users run business rules or reports some xref sessions are freezing. I cannot kill them. What can I do? Any commnets? (Hypeion Planning Versin 11.1.1.3)

Edited by: tarum on 19.Haz.2010 03:13
  • 1. Re: Essbase XREF Freezing problem
    _RahulS_ Guru
    Currently Being Moderated
    If you just want to kill the session, then kill the ESSSVR process.

    However, find out the root cause why XREF is making the session freeez.
  • 2. Re: Essbase XREF Freezing problem
    tarum Newbie
    Currently Being Moderated
    There are business rules running on each database. Rutes are retrieving data form each database. After a while I see freezing xref sessions. I kill the essrv process from the task manager, but it is not a solution. Do you have anay idea for the reason of this xref problem?
  • 3. Re: Essbase XREF Freezing problem
    CL Oracle ACE Director
    Currently Being Moderated
    After a while I see freezing xref sessions.
    ^^^What exactly do you mean by that? Are there still other calc sessions running and these run alongside do you look at the running sessions and only see XREF functions running? Does their running impact anything else? Can you stop the Essbase databases in question? Are you sure you don't have small run on form save calcs that constantly fire these?

    Here's another thought -- have you tried converting what are likely dynamically calculated XREFs to stored XREFs and see what the difference is? I am not the world's biggest fan of dynamically calculated XREFs because of performance reasons.

    Regards,

    Cameron Lackpour
  • 4. Re: Essbase XREF Freezing problem
    _RahulS_ Guru
    Currently Being Moderated
    Along with CL’s suggestion,
    Xref is very sensitive to the member block and the order in which you have written source and target combination.

    I have experienced that if you change the member block from denser member to less dense member, there will be drastic amount of change in the running time of business rule. Suggest you to mention the source and target combination in the outline order and try to keep the member block most dense dimension.
  • 5. Re: Essbase XREF Freezing problem
    CL Oracle ACE Director
    Currently Being Moderated
    I have experienced that if you change the member block from denser member to less dense member, there will be drastic amount of change in the running time of business rule.
    ^^^ Huh? You mean if you make the target of an XREF a dense member versus a sparse member, calulating the sparse member is faster? How? The same block is pulled into memory (or created on the fly if stored)?

    Or a more dense sparse dimension member is faster than a more sparse sparse dimension member?

    That still doesn't make sense.

    Regards,

    Cameron Lackpour
  • 6. Re: Essbase XREF Freezing problem
    _RahulS_ Guru
    Currently Being Moderated
    If you want to copy an account say P00010A from REV to EXP and the source and destination combinations are:

    Accounts Period Dense3 Sparse 1 Sparse 2
    REV P00010A All X1 All X2
    EXP P00010A All X1 All NA

    FIX on level 0 of sparse
    "P00010A"
    (
    X1 = @XREF(_REV_,X1,X2);
    );
    will take less time then

    "X1"
    (
    "P00010A" = @XREF(_REV_,"P00010A",X2);
    );



    You can anytime use reference cubes to imporve @XREF performace:
    http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_techref/frameset.htm?copyrite.htm

    CL:
    Cant tell you the exact differnce in time BUT was at least 4 or 5 times more.

    Edited by: RahulS on Jun 19, 2010 8:13 PM

    Edited by: RahulS on Jun 19, 2010 8:29 PM
  • 7. Re: Essbase XREF Freezing problem
    CL Oracle ACE Director
    Currently Being Moderated
    Rahul,

    Are you saying that if you declare a calc block on a smaller dense dimension, and then assign the data to a different, larger dense dimension it's faster than if you do it the other way around? And you do the calc block declaration to "FIX" the cross dim on the target side? And then depending on which way you declare the calculation block and the concomitant formula, it's faster one way or the other?

    And you've benchmarked this across multiple databases? What's the percentage difference in performance?

    Regards,

    Cameron Lackpour
  • 8. Re: Essbase XREF Freezing problem
    tarum Newbie
    Currently Being Moderated
    I cannot understand the problem. When I check the sessions I dont see any calculation or report activities. But there are lots of xref sessions remaining from previous calculations or reports. Do you have another idea instead of using two or more planning databases for different modelling needs?
  • 9. Re: Essbase XREF Freezing problem
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    Are you any of the xrefs against dense members with two pass applied, if so I have seen issues where xref sessions end up in a endless loop, I ended up having to put an essbase configuration setting to get around it.

    You can read about the setting and see if that is what you are experiencing :- http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_techref/frameset.htm?forcealldensecalcon2passaccounts.htm

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 10. Re: Essbase XREF Freezing problem
    tarum Newbie
    Currently Being Moderated
    Thaks John,
    I put the essbase configuration setting in the essbase.cfg file.
    FORCEALLDENSECALCON2PASSACCOUNTS FALSE
    I restarted the essbase services but it didnt work.
    I see the same xref sessions....

    This is my .cfg file (directory: D:\Hyperion\products\Essbase\EssbaseServer\bin )

    ; The following entry specifies the full path to JVM.DLL
    JvmModuleLocation D:\Hyperion\common\JRE-64\Sun\1.5.0\bin\server\jvm.dll
    BPM_Oracle_DriverDescriptor "MERANT OEM 5.2 64-BIT Oracle Wire Protocol"
    BPM_DB2_DriverDescriptor "MERANT OEM 5.2 64-BIT DB2 Wire Protocol"
    BPM_SQLServer_DriverDescriptor "MERANT OEM 5.2 64-BIT SQL Server Wire Protocol"
    BPM_SQLServer_DriverDescriptor "SQL Server"
    ;BPM_Netezza_DriverDescriptor "NetezzaSQL"
    BPM_Teradata_DriverDescriptor "Teradata"
    BPM_ORACLEBI_DriverDescriptor "Oracle BI Server"
    AuthenticationModule CSS
    AGENTPORT 1423
    SERVERPORTBEGIN 32768
    SERVERPORTEND 33768
    AGENTDESC hypservice_1

    CALCLOCKBLOCKHIGH 500000
    CALCLOCKBLOCKDEFAULT 50000
    CALCLOCKBLOCKLOW 1000
    FORCEALLDENSECALCON2PASSACCOUNTS FALSE

    Edited by: tarum on 19.Haz.2010 19:08
  • 11. Re: Essbase XREF Freezing problem
    CL Oracle ACE Director
    Currently Being Moderated
    Can you run just one of these XREF calcs and get the hanging XREF calc?

    If you convert the XREF to stored, does the calc still hang?

    Regards,

    Cameron Lackpour
  • 12. Re: Essbase XREF Freezing problem
    tarum Newbie
    Currently Being Moderated
    Thanks Cameron,
    I cannot catch the hanging xref. It occures while retrieving data or report or running calc script.
    Sometimes it doesnt occure. If the number of users in the system increases, I see the unkillable xref sesions.
    The Planning application has two plan types. They work together, so there will always be dynamic passes.
    There are always xref jobs on retrieving. But they shouldnt be hanged...
  • 13. Re: Essbase XREF Freezing problem
    tarum Newbie
    Currently Being Moderated
    I have solved this issue. I changed the source of dynamic total members to my defauld cube. Now I have no xref freezing problem. But I have still performance problems with fiinancial reporting. Thanx all...
  • 14. Re: Essbase XREF Freezing problem
    632961 Newbie
    Currently Being Moderated
    tarum wrote:
    I changed the source of dynamic total members to my defauld cube.
    I have the same problem. Can you describe in detail how did you resole this problem?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points