Lets Learn Hyperion

Search This Blog

Essbase environment in DWH

July 06, 2017

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Differences between ASO and BSO in Hyperion essbase

Sno Characteristics ASO(aggregate storage option) BSO(block storage option) 1 Definition ASO cubes are designed to provide rapid aggregation capabilities for much larger Essbase outlines, Typically supports large flat dimensions BSO cubes typically contain fewer dimensions than ASO cubes, and perform numerous & complex calculations on smaller outlines 2 Storage In BSO, it uses 2 types of internal storage structures to store and access data 1.data block 2.index In ASO, data will be stored in aggregate views, only level 0 blocks exist 3 calculations ASO supports MDX formulas BSO supports calculation scripts 4 Loading data We can load data at level0 members only We can load data at any level 5 Dimensionality High Low 6 Dimensionality ...

Differences between UDA and attribute?

Sno UDA Attribute 1 UDA is a flag or label Attribute is a member 2 Through UDA’s we can group and analyze both dense and sparse dimension members Through attributes we can group and analyze the sparse dimension members only 3 We can associate one or more UDA’s to one standard dimension members We can associate only one attribute member to the standard dimension member 4 UDA’s can associate at any level or at any generation Attribute members can associate at same generation or any level 5 text We can use attribute types like Boolean, text, numeric, date 6 Calculations are not possible Calculations possible through five functions like sum, count, min, max, avg 7 We can use UDA’s in calc scripts We can’t use attribute members in calc scripts

CLEARBLOCK command in essbase

CLEARBLOCK: Clear block command clears blocks of data and sets them to #MISSING. If you use CLEARBLOCK within FIX command, Essbase clears only the the cells within the fixed range, and not the entire block. Syntax : CLEARBLOCK ALL / UPPER / NONINPUT / DYNAMIC / EMPTY; CLEARBLOCK ALL command : clears and removes all blocks. CLEARBLOCK UPPER command : clears consolidated level blocks or upper level blocks. CLEARBLOCK NONINPUT command : clear blocks containing derived values. Applies to blocks that are completely derived from calaculation operation. CLEARBLOCK DYNAMIC command : clears blocks containing values derived from dynamic calc and dynamic calc and store combinations. CLEARBLOCK EMPTY command : removes empty blocks(blocks which contains all #MISSING values).

Powered by Blogger

Essbase environment in DWH

Comments

Post a Comment