@2009-02-02 10:09:34.691$)אx,=x(^ƆI#x;xXxx߭b^ƆI,^ƆIٌxxx^ƆIld+ld+ +4lp.dL"LZEast Region ManageradminIn0턼bJ[F*M%nܗաP *ɁMày mE eastern_user)0턼bJ[F*M%nܗաP *ɁMày mGMark-GnD0턼bJ[F*M%nܗաP *ɁMày m$ DAC Analysis $f$c$$ $D $ ) Relationship_2004:23451233341748 o) * ) + | Relationship_2004:26841233345831o| } | ~ d Relationship_2004:31721233347370od e d f A Relationship_2004:33931233347639IoA B A C D Relationship_2004:33961233347647JoD E D F g Task Depth  <ggMUcgiEnd Time  <iiKQcij Error Code  <jjQXcjkExecution Type Name  <kkRYckl# Failed  <llPWcll rPhysical Source Name  <rrSZcrtPhysical Target Name  <ttT[ctvROW_WID  <vqvOcvwRun Mode  <wwU\cwy Server Name  <yyV]cy{ Start Time  <{{Pc{|Status  <||W^c|}Status Description  <}}X_c}~ Task Name  <~~LTc~ # Succesful  <OVc  Version ID  <Y`cPriority  < bMROW_WID  < q D Truncate Flag  <$ cNTruncate Full Load Flag  <% dO Analyze Flag  < _J Inactive Flag  <   `K  Task Description  <   F  Optional Flag  <   aL / Folder Name  <0 / / \G/ 3 Phase Name  <4 3 3 ]H3 7 Task Group Name  <8 7 7 ^I7 6 Day <k 6 6 eqI 6 G 6 7 Day Name <l 7 7 fH 7 8 Day of Month <m 8 8 gI 8 9 Day of Week <n 9 9 hJ 9 : Day of Year <o : : iK : ; Fiscal Quarter <p ; ; mO ; < Fiscal Year <q < < nP < > Month Name <s > > oQ > E Calendar Month <g E E jL E F Calendar Week <h F F kM F G Calendar Year <i G G lN G F Analyze Flag <b F F t<D F G Analyze Truncate Flag <U G G u=D G H Comments <V H H r:D H I Drop and Create Indexes Flag <W I I v>D I J Full ETL Flag <X J J w?D J K Inactive Flag <Y K K x@D K L Keep Dates Flag <Z L L yAD L M Last Designed Flag <[ M M zBD M N Last Updated Flag <\ N N {CD N O Execution Plan Name <] O O q9D O P # Prune Days <^ P P |DD P P  Q ROW_WID <_ Q qT Q 8D Q R Status <` R R s;D R S Version ID <a S S }ED S  Comments5 <6   ,   End Time6 <7   *   ETL_PROC_WID9 <:   5   # Failed: <;   /     Description< <=   +   # Queued= <>   0     ROW_WID> <?  q+  (  ! # Runnable? <, ! ! 1 ! !  " # Running@ <- " " 2 " "  $ Start TimeB </ $ $ ) $ % StatusC <0 % % 3 % & Status DescriptionD <1 & & 4 & ( # SuccessfulF <3 ( ( . ( (  ) # TotalG <4 ) ) - ) )  * Version IDH <5 * * 6 * Row Throughput / Second <Sc. Task Name <EElapsed Time in Seconds <Rc{i ETL_PROC_WID <acROW_WID kclcqv ROW_WID k l q I DAY_DTk I l I qI 6 T W_ETL_DEFN_KeykD T lD T qT Q + W_ETL_DEFN_RUN_KeyKk + l + q+  * Role_2010:23461233341991m* o) * + Role_2010:23471233341991mc+ o) + } Role_2010:26851233345853m } o| } ~ Role_2010:26861233345853mc~ o| ~ e Role_2010:31731233347416mD e od e f Role_2010:31741233347416mcf od f B Role_2010:33941233347663mD B oA B C Role_2010:33951233347663m C oA C E Role_2010:33971233347663m E oD E F Role_2010:33981233347663m F oD F c Task Runs f$ckclcmc+ c~ cf OcvPc{QciRcScTc~UcgVcWclXcjYckZcr[ct\cw]cy^c|_c}`cacccdjTasks f$k l m* DEF G/ H3 I7 JK L MNO( p Datesf$ k I l I m }  E G 6 H 7 I 8 J 9 K : L E M F N G O ; P < Q >  {   D Execution Plansf$D kD T lD T mD e D B 8D Q 9D O :D H ;D R <D F =D G >D I ?D J @D K AD L BD M CD N DD P ED S D c D E <d Execution Plan Runs3f$ k + l + m C  F (  ) $ *  +  ,  - ) . ( /  0  1 ! 2 " 3 % 4 & 5  6 *  @   uW_ETL_RUN_STEP% c g   i   j   k   l   r   t   v   w   y   {   |   }   ~           j e  e     e( W_ETL_STEP$ (                         /  } 3   7     z , z                   ,  z  { S_ETL_DAY { E   F   G   6   7   8   9   :   ;   <   >   c W_ETL_DEFND c  F  G  H  I  J  K  L  M  N  O  P  Q  R  S   @ W_ETL_DEFN_RUN` @    f   g   j   k   m   n   o !  p "  q $  s %  t &  u (  w )  x *  y edSources cdSources  Sources  E SourcesD E  Sources4   Measure   l  Measure     Measure  P   Measure     Measure     Measure  !   Measure  "   Measure  (   Measure )   AggRule_2050:30891233346972   3l AggRule_2050:30911233346972   3 AggRule_2050:35721233348736  3P  AggRule_2050:35741233348736  3  AggRule_2050:35761233348736  3  AggRule_2050:35781233348736  3!  AggRule_2050:35801233348736  3"  AggRule_2050:35821233348736  3( AggRule_2050:35841233348736  3) eW_ETL_DEFN_RUN / e f e g e h e i e j e k e l e m e n e o e p e q e r e s e t e u e v e w e x e y0 e !1 e 2 e g 6 d el z W_ETL_FOLDER / z { z | z } z ~ z  z  z  z 0 z 6 d z8l W_ETL_GROUP_STEP /                0  1    6 d  Jl  W_ETL_PHASE /              0  6 d l W_ETL_RUN_STEP /                                                          0  1    2  6 d "D@   W_ETL_STEP /                                                                 0  1    , 6 d I  @l  S_ETL_DAY /                                      0  2    g 6  Wl W_ETL_GROUPo /                                 0 6 d I  +l W_ETL_DEFN/              0 6 d Hl fCOMMENTS> / e fsysteml gEND_TS? / e gsysteml h ETL_DEFN_NAME@ / e h2systeml i ETL_DEFN_WIDA - i/ e i2systeml j ETL_PROC_WIDB / e j systeml k FAILED_STEPSC / e k systeml lLAST_UPDD / e lsysteml mNAMEE / e msysteml n QUEUED_STEPSF / e n systeml oROW_WIDG . ! o/ e o2systeml pRUNNABLE_STEPSH / e p systeml q RUNNING_STEPSI / e q systeml r SCHEDULE_WIDJ / e r2systeml sSTART_TSK / e ssysteml tSTATUSL / e tsysteml u STATUS_DESCM / e usysteml vSTEPS_CRTD_FLGN / e vsysteml w SUCC_STEPSO / e w systeml x TOTAL_STEPSP / e x systeml y VERSION_IDQ / e y systeml {COMMENTSR / z {systeml |LAST_UPDS / z |systeml }NAMET / z }systeml ~ PARENT_WIDU / z ~2systeml PRIORITYV / z  systeml ROW_WIDW .  / z 2systeml TYPE_CDX / z 2systeml  VERSION_IDY / z  systeml APP_WID /  2systeml  GROUP_WID - .  /  2systeml GRP_EXEC_ORDER /   systeml  INACTIVE_FLG /  systeml LAST_UPD /  systeml ROW_WID /  2systeml STEP_WID -  .  /  2systeml  VERSION_ID /   systeml COMMENTS /  systeml  INTERNAL_FLG /  systeml LAST_UPD /  systeml NAME /  2systeml PRIORITY /   systeml ROW_WID .  /  2systeml  VERSION_ID /   systeml APP_WID /  2systeml  DEFN_STEP_WID /  2systeml DEPTH /   systeml DURATION /   systeml END_TS /  systeml  ERROR_CODE /   systeml EXEC_TYPE_NAME /  dsysteml  FAILED_ROWS /   systeml  GROUP_NAME /  dsysteml LAST_UPD /  systeml  PHASE_NAME /  dsysteml PHY_FOLDER_NAME /  systeml PHY_FOLDER_WID /  2systeml  PHY_SRC_NAME /  2systeml  PHY_SRC_WID /  2systeml  PHY_TRGT_NAME /  2systeml  PHY_TRGT_WID /  2systeml ROW_WID .  /  2systeml RUN_MODE /  dsysteml RUN_WID -  /  2systeml  SERVER_NAME /  systeml  SERVER_WID /  2systeml START_TS /  systeml STATUS /  systeml  STATUS_DESC /  systeml  STEP_NAME /  dsysteml STEP_WID -  /  2systeml  SUCESS_ROWS /   systeml  VERSION_ID /   systeml  ANALYZE_FLG /  J  systeml APP_WID /  J  2systeml  ARGUMENTS /  J  systeml  BLD_IMG_FLG /  J  systeml CMD_NAME /  J  systeml COMMENTS /  J  systeml CONT_ON_ERR_FLG /  J  systeml EXEC_WID /  J  2systeml  FL_CMD_NAME /  J  systeml  FOLDER_WID - , /  J  2systeml  GROUP_FLG /  J  systeml GRP_SERIAL_FLG /  J  systeml  INACTIVE_FLG /  J  systeml  INTERNAL_FLG /  J  systeml LAST_UPD /  J  systeml NAME /  J  dsysteml  OPTIONAL_FLG /  J  systeml  PHASE_WID -  /  J  2systeml  POST_COMMAND /  J  systeml POST_FL_COMMAND /  J  systeml  PRE_COMMAND /  J  systeml PRE_FL_COMMAND /  J  systeml PRIORITY /  J   systeml RESTART_ALL_FLG /  J  systeml ROW_WID .  /  J  2systeml SRC_DBCONN_WID /  J  2systeml  TEMPLATE_FLG /  J  systeml TRGT_DBCONN_WID /  J  2systeml  TRUNC_FLG! /  J  systeml TRUNC_FULLLOAD_FLG" /  J  systeml TYPE_WID# /  J  2systeml  VERSION_ID$ /  J   systeml  CAL_MONTH% /  systeml CAL_WEEK& /  systeml CAL_YEAR' /  systeml  DAY_AGO_DT( /  systeml DAY_DT) .  /  systeml DAY_NAME* /   systeml  DAY_OF_MONTH+ /  systeml  DAY_OF_WEEK, /  systeml  DAY_OF_YEAR- /  systeml FSCL_QTR. /  systeml  FSCL_YEAR/ /  systeml  MONTH_AGO_DT0 /  systeml  MONTH_NAME1 /  systeml PER_NAME_MONTH2 /  2systeml  PER_NAME_QTR3 /  systeml QUARTER_AGO_DT4 /  systeml ROW_WID5 /  systeml  WEEK_AGO_DT6 /  systeml  YEAR_AGO_DT7 /  systeml ANALYZE_FLGp / J  systeml APP_WIDq / J  2systeml ARGUMENTSr / J  systeml BLD_IMG_FLGs / J  systeml CMD_NAMEt / J  systeml COMMENTSu / J  systeml CONT_ON_ERR_FLGv / J  systeml EXEC_WIDw / J  2systeml FL_CMD_NAMEx / J  systeml FOLDER_WIDy / J  2systeml GROUP_FLGz / J  systeml GRP_SERIAL_FLG{ / J  systeml INACTIVE_FLG| / J  systeml INTERNAL_FLG} / J  systeml LAST_UPD~ / J  systeml NAME / J  dsysteml OPTIONAL_FLG / J  systeml PHASE_WID / J  2systeml POST_COMMAND / J  systeml POST_FL_COMMAND / J  systeml PRE_COMMAND / J  systeml PRE_FL_COMMAND / J  systeml PRIORITY / J   systeml RESTART_ALL_FLG / J  systeml ROW_WID . / J  2systeml SRC_DBCONN_WID / J  2systeml TEMPLATE_FLG / J  systeml TRGT_DBCONN_WID / J  2systeml TRUNC_FLG / J  systeml TRUNC_FULLLOAD_FLG / J  systeml TYPE_WID / J  2systeml VERSION_ID / J   systeml ANALYZE_FLG/ dacl ANALYZE_TRUNC_FLG/ dacl COMMENTS/ dacl DRP_CRT_IND_FLG/ dacl FULL_ETL_FLG/ dacl INACTIVE_FLG/ dacl KEEP_DATES_FLG/ dacl LAST_DESIGN_DT/ dacl LAST_UPD/ dacl NAME/ 2dacl PRUNE_DAYS/  dacl ROW_WID. / 2dacl STATUS/ dacl VERSION_ID/  dacl W_ETL_STEP_FKey ,  -  1   W_ETL_GROUP_STEP_FKey ,  -  1   W_ETL_RUN_STEP_FKey ,  -  1   W_ETL_RUN_STEP_FKey#1 ,  !-  1   , W_ETL_STEP_FKey#1 , , - , 1  , W_ETL_GROUP_STEP_FKey#1 , - 1  W_ETL_DEFN_RUN_FKey, - i1 e DAY_DT` .  0   ROW_WIDb , , .  0 z   GROUP_WIDd .    0   ROW_WIDe ,  .  0   ROW_WIDf .  0   ROW_WIDg ,    .  0   !W_ETL_DEFN_RUN_Key ,  !. ! o0 e ! W_ETL_STEP_GROUP_Key , . 0 W_ETL_DEFN_Key, . 0 S_ETL_DAY_W_ETL_RUN_STEP2    ,< z { g S_ETL_DAY_W_ETL_DEFN_RUN2  g  e g ,< z s{ ORCL7  d  8  , dd@11   english-usa/**/ dDAC 6 d e d z d  d  d  d  d  d 7  d  S_NQ_ACCT 6  7   Connection Pool8   orclsh0턼bJ[F*M%nܗJ(n-\z:򠞬Mày, 3D:\oracle\OracleBI\server\config\NQSQueryHeader.xml4D:\oracle\OracleBI\server\config\NQSQueryTrailer.xml TT  Current Monthw  BI_EE_HOME1:C:\oracle\product\OracleBI Hyperion?HQBC:\oracle\product\OracleBI\web\bin\sawobisauthenticatorproxy3r.dll 턼bJ[F*M%nܗլMày<<AD_3900:21801233341991  <v  <<AD_3900:21811233341991  <w  <<AD_3900:21831233341991  <y  <<AD_3900:21851233341991  <{  <<AD_3900:21861233341991  <|  <<AD_3900:21871233341991  <}  <<AD_3900:21881233341991  <~  <<AD_3900:21901233341991  <  <<AD_3900:21911233341991  <  <<AD_3900:21941233341991  <g  <<AD_3900:21961233341991  <i  <<AD_3900:21971233341991  <j  <<AD_3900:21981233341991  <k  <<AD_3900:21991233341991  <l  <<AD_3900:22051233341991  <r  <<AD_3900:22071233341991"  <t  << AD_3900:23121233341991#  <   << AD_3900:23241233341991  <   << AD_3900:23271233341991  <   << AD_3900:23281233341991  <   << AD_3900:23341233341991  <   << AD_3900:23361233341991  <   <<$ AD_3900:23401233341991  <$   <<% AD_3900:23411233341991  <%   <<0 AD_3900:23521233341991  <0 /  }<<4 AD_3900:23561233341991  <4 3  <<8 AD_3900:23601233341991  <8 7  <<g AD_3900:26631233345853 <g E  <<h AD_3900:26641233345853 <h F  <<i AD_3900:26651233345853 <i G  <<k AD_3900:26671233345853 <k 6  <<l AD_3900:26681233345853 <l 7  <<m AD_3900:26691233345853 <m 8  <<n AD_3900:26701233345853 <n 9  <<o AD_3900:26711233345853 <o :  <<p AD_3900:26721233345853 <p ;  <<q AD_3900:26731233345853 <q <  <<s AD_3900:26751233345853 <s >  <<U AD_3900:31571233347416 <U G  <<V AD_3900:31581233347416 <V H  <<W AD_3900:31591233347416 <W I  <<X AD_3900:31601233347416 <X J  <<Y AD_3900:31611233347416 <Y K  <<Z AD_3900:31621233347416 <Z L  <<[ AD_3900:31631233347416 <[ M  <<\ AD_3900:31641233347416 <\ N  <<] AD_3900:31651233347416 <] O  <<^ AD_3900:31661233347416 <^ P  <<_ AD_3900:31671233347416 <_ Q  <<` AD_3900:31681233347416 <` R  <<a AD_3900:31691233347416 <a S  <<b AD_3900:31701233347416 <b F  <<, AD_3900:33721233347663L <, !  p<<- AD_3900:33731233347663M <- "  q<</ AD_3900:33751233347663O </ $  s<<0 AD_3900:33761233347663P <0 %  t<<1 AD_3900:33771233347663Q <1 &  u<<3 AD_3900:33791233347663S <3 (  w<<4 AD_3900:33801233347663T <4 )  x<<5 AD_3900:33811233347663U <5 *  y<<6 AD_3900:33821233347663V <6   f<<7 AD_3900:33831233347663W <7   g<<: AD_3900:33861233347663Z <:   j<<; AD_3900:33871233347663[ <;   k<<= AD_3900:33891233347663] <=   m<<> AD_3900:33901233347663^ <>   n<<? AD_3900:33911233347663_ <?   o<<AD_3900:37341233349040 <<<AD_3900:37401233349368 <  <<AD_3900:37481233352316 <<<AD_3900:37541233354432 <  j DAC Analysis23456$Tasks3 {|}\~]^_`abcdDates4 yezf{g|h}i~jklmnoExecution Plans5 qrstuvwxyz{|}Execution Plan Runs6 Task Runs2KLMOPQRSTUVWXYKEnd TimeKiKL Task NameL~LM Task DepthMgMO # SuccesfulOOP# FailedPlPQ Error CodeQjQRExecution Type NameRkRSPhysical Source NameSrSTPhysical Target NameTtTURun ModeUwUV Server NameVyVWStatusW|WXStatus DescriptionX}XY Version IDYY\ Folder Name}\/ \] Phase Name~]3 ]^Task Group Name^7 ^_ Analyze Flag__` Inactive Flag` `a Optional Flaga abPrioritybbc Truncate FlagccdTruncate Full Load FlagddeDayye6 efDay Namegzf7 fg Day of Monthh{g8 gh Day of Weeki|h9 hi Day of Yearj}i: ijCalendar Monthk~jE jk Calendar WeeklkF kl Calendar YearmlG lmFiscal Quarternm; mn Fiscal Yearon< no Month Namepo> oqExecution Plan NamerqO qrCommentssrH rsStatustsR st Analyze FlagutF tuAnalyze Truncate FlagvuG uvDrop and Create Indexes FlagwvI vw Full ETL FlagxwJ wx Inactive FlagyxK xyKeep Dates FlagzyL yzLast Designed Flag{zM z{Last Updated Flag|{N {| # Prune Days}|P |} Version ID~}S } Start Time$ End Time  Description Comments # Total)  # Successful( # Failed # Queued  # Runnable!  # Running" Status% Status Description&  ETL_PROC_WID  Version ID*  Start Time{Row Throughput / Second Task Name{Task Description| Elapsed Time in Seconds Elapsed Time ETL_PROC_WIDnnAdministratorsnnnn ExecutivennnnRegion Managernnqnn XMLP_ADMIN BI Publisher Administrator Group:nnnXMLP_DEVELOPERBI Publisher Developer Group;nnXMLP_SCHEDULERBI Publisher Scheduler Group<nnXMLP_ANALYZER_EXCEL!BI Publisher Excel Analyzer Group=nnXMLP_ANALYZER_ONLINEBI Publisher Online Analyzer8nnXMLP_TEMPLATE_DESIGNER$BI Publisher Template Designer Group9nnDusers'GnDqqPrivPack_4209:16704985826474nq