-
编辑 删除
calculate parallelly
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 ("...
-
编辑 删除
calculation for time balance property, formula, two pass
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...
-
编辑 删除
essbase export and import
for essbase export option:set dataexportoptions{DataExportLevel Level0;DataExportDimHeader on;}; export has 4 parameters:dataexport "File" "," "filename.txt" "#MI"; for import...
-
编辑 删除
dimension order in a outline
it's called modified hourglass model or hourglass model in a stick: account dimensiontime dimensionlargest dense dimensionsmallest dense dimensionsmallest sparse dimensionlargest sparse di...
-
编辑 删除
essbase calcuation order
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], ...
-
编辑 删除
trigger for essbase
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...
-
编辑 删除
dynamic calculation
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 block creation
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...
-
编辑 删除
"=" in Essbase calculation
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...
-
编辑 删除
BSO or ASO essbase
ASO is good due to its speed, less space, etc. but it has many limitations.for a reporting cube, the first choice should be ASO.Now if a reporting cube has time-balance set, which require TIME dimensi...
