Lets Learn Hyperion

Search This Blog

what is outline?

August 09, 2017

Get link
Facebook
X
Pinterest
Email
Other Apps

outline is a structural representation of a database.

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

CLEARDATA command in Essbase

CLEARDATA: CLEARDATA command clears data values from the database and sets them to #MISSING. CLEARDATA does not work if placed in IF statement. CLEARDATA can only clear a section of a database, not clears or removes entire block. SYNTAX: CLEARDATA mbrname; (mbr name can be a single member or combination of members) EX: 1.CLEARDATA India; (clears india data) 2.CLEARDATA India ->sales; (clears sales data for india) 3.FIX(Actual) CLEARDATA "electronics"; ENDFIX (it only clears the electronics block, but not remove the block)

Powered by Blogger

what is outline?

Comments

Post a Comment