SimCorp Dimension Database

Course Objective:

The purpose of the course is to learn the database structure of SimCorp Dimension. Understanding the database structure will both ease the use of SimCorp Dimension for you as end-user as well as making the Data Extraction and report developing a much easier task.
The scope of the course is to give the participants a basis for report developing and analysis through any report generator. It is out of the scope of this course to describe the report generators. However, during the course we use Seagate Crystal Reports and SQL developer to retrieve data.

Introduction to Database Theory

  • What is a Database?
  • Normalized Database
  • Structured Query Language
  • Joining Tables
  • Database Views
  • Domain Values
  • Using online help to retrieve field and table names

SimCorp Dimension Database Structure

  • Static and Reference Data Structure
  • Transactions structure
  • Holdings structure
  • Market data structure
  • Portfolio calculation

Multi-legged Instruments

  • Deposits
  • FX Instruments
  • Swaps

Pre-requisites:

Basic database understanding (tables, fields, SQL, joins)

Course Duration:

Days: 1 day

Daily training hours: 9:00-17:00

Course Fee: EUR 925 (excl. VAT)

How to register for this course

Click your preferred date below and register by filling out the form.

If no date is found for your preferred course please contact coursebooking@simcorp.com to request the course.