Data Model

The intention of the course is to provide an overview of the SimCorp Dimension Data Model and knowledge to create own evaluations and reports.

In the course, parts of the data model of SimCorp Dimension are presented and SQL queries are performed optionally with SQL*Plus or the SQL developer.

Main Learning Topics:

  • Data base theory
  • Data model
  • Basic knowledge Data Extractor
  • The database structure will be introduced in following parts:
    • Security and FX prices
    • Static Data
    • Holdings and Transactions
    • Portfolio Calculation
    • (Funds) Figures
    • Unified Log
    • Report Views

Pre-requisites:

Participants are recommended to have basic knowledge in the modules static data, reference data, portfolio calculation etc. Additionally the participants should have general knowledge in database SQL.

Course Duration:

Days: 1 day

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.