什么是ESSBASE多维的OLAP数据平台;对数据从导入、存储、计算、汇总、分析、报表进行全方位处理预算实际销售成本毛利比率1月2月3月1季度BudgetActualSalesCOGSGrossMarginRatiosJanFebMarQtr1切片切块BudgetActualSalesCOGSGrossMarginRatiosJanFebMarQtr1单元格BudgetActualSalesCOGSGrossMarginRatiosJanFebMarQtr11Copyright©2005,&统计财务智能化&币种转换预测&时间序列智能化数据挖掘、回归预报分析多用户回写Procedural,Set,Relationship&BooleanLogicStoredProcedures,Triggers,&CustomFunctions/Macros100%并行架构可大规模扩展EssbaseAnalyticServicesBenefits改善需求绩效–划分市场,识别销售机会,增加线索形成,精确预见需求改善供应绩效–使供应、制造、和物流与变化的市场需求协调统一,以降低成本,投资于收入项目机会改善财务绩效–建立收益模型,完善计划,分摊资源,使业务运营与战略目标协调统一2Copyright©2005,(Correlation,Trend,Analysis)VarianceReporting(Actual,Budget,Variance)InventoryTracking(Opening&EndingBalance)Attributes(Style,Color,Sizeetc)Slicing,Dicing&PivotingAnalysisMulti-CurrencySupport(US,HK,SIG……)ReportingusinglocalcurrencyTrackingandUpdatingcurrencycubeusingExcelWhat-IfanalysisMulti-userread/writeenvironment(Write-plexAllocationBusinessAnalysis3Copyright©2005,("TotalExpenses")Budget=***@ALLOCATE(Budget->"TotalExpenses",***@CHILDREN("TotalExpenses"),"PYActual“,,share);ENDFIX4Copyright©2005,ForTheEntireBusinessBusinessrulesForecastingPlanningCurrencyWhat-if?FINANCIALMassivedatavolumesRealtimeMiningNavigationSparsedimensionsOPERATIONALNewNewNew5Copyright©2005,©2005,Data&ProcessesFinancialManagement&ControlEnterprisePlanningQuery&ReportingEnterpriseAnalyticsWithanEnterpriseBPMSystemDestination/End-UsersHyperionBPMSystemDataSourcesDataWarehouseLegacySiebelSAPOracleOPERATIONALREPORTINGINTERACTIVEDASHBOARDFINANCIALREPORTING7Copyright©2005,-UX
Hyperion BI介绍 来自淘豆网m.daumloan.com转载请标明出处.