twg-group-chennai

ORACLE ESSBASE TRAINING IN CHENNAI :

SYLLABUS :


Overview of Oracle Essbase :


  • Describe multidimensional analysis
  • Describe Oracle Essbase
 

Smart View :


  • Describe Smart View
  • Retrieve Data using Smart View
 

Aggregate Storage Databases :


  • Describe when to deploy aggregate storage, block storage, or a combined solution
  • Convert block storage to aggregate storage
  • Create, load, and pre-aggregate aggregate storage databases
  • Employ database partitioning in combined block/aggregate storage solutions
  • Write member formulas using MDX
  • Perform management tasks for aggregate storage databases
  • Partition block and aggregate storage databases
  • Describe and implement aggregate storage design best practices
  • Describe multiple hierarchies and the use of Shared Members
 

Block Storage Databases :


  • Describe block storage calculations
  • Describe the default database calculation order
  • Describe data blocks
 

Describe how data blocks are indexed :


  • Interpret database statistics
  • Describe when data blocks are created
  • Describe the block storage database calculation process
  • Tune and optimize block storage databases
  • Describe and implement block storage design best practices
  • Describe BSO load techniques Working with Calculation Scripts
  • Identify correct and incorrect calculation script syntax
  • Describe calculation script behaviour for various ASO data structures
  • Describe calculation script behaviour for various BSO data structures
  • Design calculation scripts to meet specified requirements
 

Essbase Administration :


  • Describe the file Essbase.cfg and its settings
  • Describe the file Essbase.sec and its settings
  • Identify and interpret Essbase log files
  • Manage Essbase security via Administration Services
  • Manage Essbase security via Shared Services
  • Back up and recover Block Storage Databases
  • Automate database processes with MaxL
  • Describe and use substitution variables and location aliases
 

Essbase Studio :


  • Describe functionality of Essbase studio
  • Add and delete joins between tables
  • Create drill through reports

 

CONTACT ADDRESS :

CHENNAI BRANCH

no.5, boopathy street, virugambakkam,
virugambakkam - bus stop opposite chennai , tamil nadu , india.
tel: 044 - 420 77677, 044 - 430 72173
cell : 093845 77677
email : twggroupchennai@gmail.com

KOCHI BRANCH

Near LULU Shopping Mall
Edappally Toll Junction,
Opposite - Metro Bridge Piller No. 387,
V.P Marakkar Building,
V.P Marakkar Road,
Via - Vanitha and Vinitha Theatre
Edappally P.O, Kochi - Kerala
Contact :073580 27788 , 093810 48884,
Email : twggroupcochin@gmail.com ,
Email : twggroupchennai@gmail.com

MUMBAI BRANCH

crescent business square" No.810, kherani road,
opposite - sj studios sakinaka metro
junction, andheri (east) mumbai - 400 059.
cell : 093810 48884, 073580 27788, 093810 77677
email : twggroupmumbai@gmail.com
email : twggroupchennai@gmail.com

TRICHY BRANCH

sri gem plaza no.3, 4th floor,
sankaran pillai street, s.r.c.college road,
chathiram bus stand, trichy - 620 002
Tamil nadu , india.
contact : jenifer : 093845 77677, 93810 77677
contact : suganya : 093825 88890
email : twggroupchennai@gmail.com

COIMBATORE BRANCH

dheepam complex no.574 to 581, 100 feet road,
near g.p.signal, landmark: kalyan jewellery,
gandhipuram, coimbatore - 641 012 tamil nadu , india.
contact : jasmine : 093810 77677, 093845 77677,
contact : sandhiya : 093825 88890
email : twggroupchennai@gmail.com

VIZAG BRANCH

twg group vizag no. 8 - 12 - 1/1,
2nd floor, gayathri nilay, gokul nagar,
karur vysya bank back side opposite - holy cross church,
old gajuwaka junction, vishakapatnam - 530 026.
Andhra pradesh , india.
contact : 073580 27788, 093810 48884, 76692 48884.
email : twggroupchennai@gmail.com

BANGALORE BRANCH

No.54, 15th Main Road ,
2nd Floor,
East of Chord Road
Vijaya Nagar,
Opposite Vijaya Nagar Metro Station,
Bangalore - 560 040.
Karnataka, India.
Contact : 073580 27788 , 093810 77677
Email : twggroupchennai@gmail.com

HYDERABAD BRANCH

twg group hyderabad contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

DELHI BRANCH

twg group delhi contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

PUNE BRANCH

twg group pune contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRIVANDRUM BRANCH

twg group trivandrum contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

CALICUT BRANCH

twg group calicut contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRAINING COURSES