Lets Learn Hyperion

Search This Blog

what is outline?

August 09, 2017

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

outline is a structural representation of a database.

Get link
Facebook
Twitter
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

Hyperion 11.1.2.4 Installation guide

Hyperion Installation 11.1.2.4 Before going to install oracle enterprise performance management suite (Hyperion), First you have to know about all EPM products. List of EPM products: Oracle Hyperion Foundation Services Foundation Services · Optionally, Oracle HTTP Server · Oracle WebLogic Server · Oracle Hyperion EPM Architect · Oracle Hyperion Calculation Manager · Oracle Smart View for Office Oracle Essbase · Oracle Essbase · Oracle Essbase Administration Services · Oracle Hyperion Provider Services · Oracle Essbase Studio Oracle Reporting Analysis and Framework · Oracle Hyperion Reporting and Analysis Framework · Oracle Hyperion Interactive Reporting · Oracle Hyperion Financial Reporting · Oracle Hyperion SQR Production Reporting · Oracle Hyperion Web Analysis Oracle Hyperion Planning ·

Powered by Blogger

what is outline?

Comments

Post a Comment