【文章內(nèi)容簡介】
? 可擴展 ? 單點維護 Essbase 的高級分析能力 ? Writeback 并發(fā)回寫 ? Allocations 智能分攤 ? timevarying attributes 時間變化屬性 ? financial intelligence 財務(wù)智能 ? Forecasting 預(yù)測 ? Clustering 聚類 ? Correlations 關(guān)系因子 34 Essbase Architecture ?Middle Tier ?Database Tier ?Client Tier ?Administration Services ?Integration Services ? MaxL and MDX ? C API, VB API, and Java API applications ?Administration ?Services Console ?Integration Services Console ?TCP/IP ?HTTP ?TCP/IP ?Essbase ?RDBMS ?ODBC ?Provider Services ?HTTP ?Essbase Spreadsheet Addin ?Smart View ?Block Storage ?Aggregate Storage ?TCP/IP Smart View Essbase Visual Explorer A Leading Global Bank in Asia Pacific Enterprise wide usage of Essbase Needs ? Create a single system for all financial data ? Automate Daily PL and Balance Sheet at country level ? Provide Flash Reporting at M+1, M+2, … before final closing of PeopleSoft GL ? Knowledge based marketing to drive incremental profit ? Client Performance Reporting Ranked in the top 25 among FTSE100 panies, by market capitalization. An extensive global work of over 1,200 branches in 56 countries 44,000 employees representing 89 nationalities, worldwide After ? 1000+ users in 56 countries for BCPR, FTP, Group Finance, CB, WB powered by Essbase ? Near realtime financial reporting ? Meet the local Regulatory Reporting requirements (HKMA, BNM in Malaysia, …) ? PL, B/S, Cash flow, … ? KPI’s on Sales Performance with advanced analysis (Product Profile, Regions, Time, …) FSI – BANKING A Leading Communication Company in China Improves Analysis Capabilities and Performance Needs ? Gather massive amount of data form different OLTP systems ? Establish unified data center for management ? Personalized reports for business users ? High Performance for Reporting ? Reduce risk in large volume usage ? One of the biggest munication pany of provincial level in China ? Provide mobile coverage to the Guangdong area of about 80 million mobile users (2023) ? Prime operating revenue over 80 billion After ? Integrated multidata source from BOSS,OA,NM,CS,HIR etc. ? Leverage multidimensional database to improve analytic performance ? Enabled different analytics model for business (customer, marketing, channel etc. ) ? Provide personalized reports through business intelligence ? Improve Adhoc query performance for thousands of simultaneous users CMU – Mobile 內(nèi)容安排 ? Oracle商務(wù)智能整體解決方案 ? 集成的商務(wù)智能技術(shù)平臺 ? 超越傳統(tǒng)的數(shù)據(jù)整合工具 Oracle ODI/GG ? 強大的 OLAP分析引擎 Oracle ESSBASE ? 靈活易用的前端展示平臺 Oracle BIEE+ ? 小結(jié) Oracle商務(wù)智能套件企業(yè)版 Plus 統(tǒng)一的商務(wù)智能基礎(chǔ)架構(gòu) OLTP和 ODS 系統(tǒng) 數(shù)據(jù)倉庫 數(shù)據(jù)集市 SAP、 Oracle PeopleSoft、 Siebel、 定制管理軟件 文件 Excel XML 業(yè)務(wù) 流程 財務(wù)績效 管理軟件 洞察力 績效 行動 Set 目標(biāo) 計劃 監(jiān)控 分析 報告 調(diào)整 Hyperion Essbase Oracle商務(wù)智能服務(wù)器 通用企業(yè)信息模型 報表編制與發(fā)布 財務(wù)報表 商務(wù)智能發(fā)布軟件 交互式報表 SQR生產(chǎn)報表 Web分析 即席 查詢 前瞻性 的檢測 和報警 Microsoft Office 交互式 信息顯示板 安全管理 元數(shù)據(jù) 智能緩存服務(wù) 集群 多進程 連接池 多維計算和集成引擎 可伸縮性 高性能 智能請求生成和優(yōu)化的數(shù)據(jù)訪問服務(wù) 支持廣泛的數(shù)據(jù)源 直接支持物理數(shù)據(jù)源 OLTP ODS Systems Data Warehouse Data Mart SAP, Oracle PSFT, Siebel Custom Apps Files Excel Lotus 語義對象層 物理數(shù)據(jù)源 數(shù)據(jù)模型對應(yīng) (SQL Gen Metadata) Mainframe Business Process 分布式查詢 ?Dimensions 維度 ?Hierarchies 層次 ?Measures 指標(biāo) ?Partitioning 分區(qū) ?Aggregation Rules 匯總規(guī)則 ?Time Series 時間序列 ?Caching 緩存 ?Mapping 映射 Oracle 商務(wù)智能企業(yè)版架構(gòu)