ITPub博客

usually:SET  CALCPARALLEL n;  where n is one less than the number of processor, soleave one process for other calcuations.but set this doesn't mean calculation will run parallely:FIX ("...

1) make sure the workforce and capex option are chosen when configuring planning2) when creating the EPMA based workforce application, no need to choose other planning type, so only workforce choosn...

1) administration->application setting->advanced setting->system settings->E-mail option->Email server2)administration->application setting->current application defaults->application settings->Workfl...

1) in Planning, a form. can be assigned to a view only user2) for opening form, dimensions need to be provisioned, otherwise there     will be error:      Sec...

say "Margin %" has  a formula: Margin % Sales, and both Qtr1 and "Margin %" are dynamic.if only time balance property is set, say First, then Qtr1->"Margin %" is equal to jan->"Margin %",formula...

for essbase export option:set dataexportoptions{DataExportLevel Level0;DataExportDimHeader on;}; export has 4 parameters:dataexport  "File" "," "filename.txt" "#MI"; for import...

 bop_subs+net_adds=eop_subsnet_adds=adj_gross_adds-net_deactsadj_gross_adds=gross_adds - FBNP deactivation:adjusted_gross_deact=NPD+PRSreactivation:  pwh,cwh,winback,pcanet_deac...

ARPU -- average revenue per userCPGA -  cost per gross addsCCU  - cash cost per user.they are all based on avg_subs  

mass allocate is to allocate values from total to certain segments, say location.the formula is:A*B/C, where A is allocated based on the ratio B/C, say total revenue is allocated along the subscribe...

mass allocate feature need special provision: planningApps->app->mass allocation.those are different from put sum value in quarter or year, the data spread in period dimension is decided b...

Financial report studio can be used to create report, but you need to be in web to run the report. need to be provisioned "Reporting and Analysis"->content manager

the usual planning model has:workforce, operation cost, profit workforce planning is for forecasting base salary, benefit, payroll tax, etc.the driving factor is headcount and average_salary,...

it's called modified hourglass model or hourglass model in a stick: account dimensiontime dimensionlargest dense dimensionsmallest dense dimensionsmallest sparse dimensionlargest sparse di...

PasswordEncryption.sh  -- encrypt password in a file, which make password in put in prompt not neededCalcMgrCmdLineLauncher.sh -- launch business rule from command line. This can be used to auto...

firstly:only "100-30"->California block exist after loaddo agg(Market)[Tue Feb 14 10:36:20 2012]EssSvr64/Sample/Basic/admin/Info(1012672)Calculator Information Message: Executing Block - [100-30], ...

can use trigger to monitor data change: CREATE TRIGGER 'Profit'.'Main'.'NBC_Detail' WHERE (NBC_Detail, Total, Department, Direct_GL, no_detail, budget,final, product,Location, FY12, Jan)WHEN NB...

Margin[dynamic]->West[dynamic]: according to the dynamic calculation order: sparse->account->time->dense->two pass firstly, the virtual block [west] will be created in memory, then margin ...

essbase blocks are created on: ( if there is no block, no pag and ind file)1) data load2) aggregation/calcuation on sparse dimension      the block number created by agg, s...

A=1   ( A is account member)   all values for A is 1A=B   (both A and B are account member)  all values for A are equal to B C=1   ( C is a spars...

in ERP, there are A,L,O,R,E, etc. (can find gl_code_combinations table)for R,E account, period_net_dr/period_net_cr will be set to 0 for each new period (transfer to other account in closing period)...