8 Replies Latest reply on Jul 10, 2018 7:35 PM by user9928941

    Hyperion Planning Business rule is spinning for a long time.

    3250922

      Hi,

      Can someone help me in reducing BR time, It is spinning for a long time. I see below warnings in Essbase.

       

       

      Current selection of task dimensions [1]  will generate an insufficient number of tasks [1] for parallel calculation. See whether calculation time can be improved by increasing the number of task dimensions by one (see SET CALCTASKDIMS topic in the Technical Reference). Also, consider using FIXPARALLEL to make custom task selections that are different from CALCPARALLEL

       

      [Mon Jul 09 17:01:38 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012668)

      Calculating [ Period(BegBalance)] with fixed members [Entity(CH_ATE); Product(AUXPS, BRI, CACL2, CO2, CL, Equipment, FASFLOK, FCOST, HARBO, HYAMSUL, HCL1, HCL2, H1, H2O2, Lime, MgCl2, CH4O, MUD, NCL, KCL, KOH, Power, PPA, Salt_Bleed, SODA, NACL, ]

       

      [Mon Jul 09 17:01:38 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012678)

      Calculating in parallel with [3] threads

       

      [Mon Jul 09 17:01:38 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012679)

      Calculation task schedule [1]

       

      [Mon Jul 09 17:01:38 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012680)

      Parallelizing using [1] task dimensions.

       

      [Mon Jul 09 17:01:38 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012681)

      Empty tasks [1]

       

      [Mon Jul 09 17:01:39 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012675)

      Commit Blocks Interval for the calculation is [10000]

       

      [Mon Jul 09 17:01:39 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012717)

      Remote bitmap cache is [Disabled]

       

      [Mon Jul 09 17:01:39 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012569)

      Formula on (or backward dependence from) member [CAD] forces calculation to execute in serial mode

       

      [Mon Jul 09 17:01:39 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012668)

      Calculating [ Currency(CAD)] with fixed members [Account(SalePr, Inter_PurchPr, Intra_PurchPr, Planning_Currency, Intra_SalePr); Entity(CH_ATE); Product(AUXPS, BRI, CACL2, CO2, CL, Equipment, FASFLOK, FCOST, HARBO, HYAMSUL, HCL1, HCL2, H1, H2O2, ]

       

      [Mon Jul 09 17:01:39 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012677)

      Calculating in serial

       

      [Mon Jul 09 17:01:39 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/2616/Info(1012550)

      Total Calc Elapsed Time : [0.704] seconds

       

      [Mon Jul 09 17:01:40 2018]Local/ERCOBUD///6536/Info(1013210)

      User [admin@Native Directory] set active on database [FinPlan]

       

      [Mon Jul 09 17:01:40 2018]Local/ERCOBUD///428/Info(1042059)

      Connected from [::ffff:192.168.0.44]

       

      [Mon Jul 09 17:01:40 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/428/Info(1013162)

      Received Command [Calculate] from user [admin@Native Directory]

       

      [Mon Jul 09 17:01:40 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/428/Info(1200481)

      Formula for member [CAD] will be executed in [TOPDOWN] mode

       

      [Mon Jul 09 17:01:40 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/7684/Info(1012675)

      Commit Blocks Interval for the calculation is [10000]

       

      [Mon Jul 09 17:01:40 2018]Local/ERCOBUD/FinPlan/admin@Native Directory/7684/Info(1012717)

      Remote bitmap cache is [Disabled]

       

      Please help.