?Oracle?Essbase?11?部署ASO數(shù)據(jù)庫(kù)培訓(xùn)課程

課程簡(jiǎn)介：

l???在?Oracle?Essbase?11?部署ASO數(shù)據(jù)庫(kù)這門(mén)課程中，你將學(xué)習(xí)到：

l???設(shè)計(jì)計(jì)開(kāi)發(fā)部署aggregate?storage?databases

l???管理aggregate?storage?databases

l???用MDX查詢(xún)語(yǔ)句構(gòu)建數(shù)據(jù)比較，計(jì)算數(shù)據(jù)比例，已經(jīng)其他成員運(yùn)算

l???實(shí)施期間報(bào)表利用?time?intelligence（智能時(shí)間）?

l???描述Essbase?ASO中的自定義計(jì)算以及分?jǐn)偅〝?shù)據(jù)分區(qū)技術(shù)）?

課程大綱：

???Essbase概覽

???Aggregate?Storage?概覽

???設(shè)計(jì)?Data?Descriptor?維度

???設(shè)計(jì)Business?View?維

???載入數(shù)據(jù)

???用Smart?View創(chuàng)建報(bào)表

???Aggregation聚合數(shù)據(jù)

???管理Aggregate?Storage?數(shù)據(jù)庫(kù)

???創(chuàng)建基本的?MDX?查詢(xún)

???創(chuàng)建?MDX?公式

???Time?Intelligence（時(shí)間智能）?概覽

???創(chuàng)建?Time?Intelligent?模型

???載入數(shù)據(jù)映射到時(shí)間日期

???創(chuàng)建時(shí)間期間報(bào)表

???計(jì)算基于時(shí)間的度量

???Time?Balance?計(jì)算

???分區(qū)技術(shù)概覽

???創(chuàng)建Partitions

???創(chuàng)建自定義計(jì)算

???創(chuàng)建分?jǐn)?/font>