Class Room and Remote Access Server.

Topics Covered

Radix INFO Offers Oracle Essbase : Understanding Multidimensional Databases Introduction to MDDB/OLAP concepts Introduction to Essbase Essbase Architecture Introduction to System 9 Difference MOLAP/ RDBM Installation and Configuration on Windows Designing Multidimensional Application & Database Drafting Outlines Adding members to Outline Dimension and Member Properties Dimension Types Member Storage Properties Practice Sessions: Trainees would have developed their first Multidimensional Application and Database Building Dimensions Setting Time and Account Dimension Properties Attribute Dimension UDA’s Difference between UDA's and Attributes and Alias Lab: Practice Sessions that covers everything that has been taught up till now Dynamic Dimension Build & Data Load Understanding Dimension Building Concepts Data Load using Spread sheet Add-in Lock and Send Understanding Data Loading Creating Rules Files Data Retrieving and Calculation Data Load using Smart View Calculating Essbase Databases Developing Formulas Defining Calculation Order Understanding Intelligent Calculation Developing Calculation Scripts Calculatating Data & Security assignment Integration with data Sources Security Assignment ASO and BSO Difference Partitioning Substitution Variable Spreadsheet Add-in - Retrieve data, Changing data, Add- in Options, Formatting and creating reports using Add-in Essbase Administration - Start/Stop Application and Database, View Server properties, Server Sessions, Server Data Locks, Locked Objects, View Server Log Files, Backup & Recovery Essbase Server Files - Essbase Agent, Essbase Server, Essbase.cfg, Essbase.sec Essbase Block Size - Calculate Block size and number of blocks, Index & Page files EXIT TEST