Release 23.10 Data Warehouse

SimCorp BI Cloud

As part of our solutions capabilities we are extending our capabilities to complement our on-premise deployment with our new offer. SimCorp BI cloud is a cloud-based BI and Analytics tool that is powered by Qlik® 

It allows you to gain unique insights into all data domains and meta information (processing / SLA details). For end users they can self server and navigate dashboards, publish and schedule content.

In addition, for power users we provide a designer environment that enables clients to add additional dashboards and reports as they see the need. So all currently available dashboards can be seen as template that can be further extended and tailored. 

• Enable business users to get visual insights to their data with flexible self-serve intuitive capabilities, including leveraging embedded NLP and NLG for natural language conversational analytics to enable actionable insights, all delivered within a native cloud application. 
• Optimize your reporting and analytics environment with single pane of discovery in our SimCorp BI, by accessing all your data at your fingerprints. Changes can be done with no dependency on IT developers.
• Save on having multiple solutions resulting in complex data reporting pipelines which can be automated for direct access to your business data. 

SimCorp BI Cloud Analytics Hub is a new way to navigate content inside SimCorp BI Cloud tenant. You can browse, search and navigate across all the datasets which SimCorp BI Cloud user have access to. 

• The hub is split into seven sections (Getting Started, Home, Favorites, Catalog, Collections, Alerts, Subscriptions). Each representing an unique way to organize the content and access new features.
• SimCorp BI Cloud user can easily organize and customize the Home section – to view only desired Qlik content.
• Catalog section provides an access to Spaces and it’s all content. 
• There is both a Global and Catalog filters where spaces, terms, charts, apps, automations, data, notes, owners, creators, and tags can be found by name.
• Qlik content can be arranged and the sorted alphabetically, by the date it was modified and by the creation date.
• In Collections section, you can view and group apps, charts, notes, automations and links into various collection groups. It can be achieved by simply clicking “Add to collection” icon on any content type.

Subscription based licensing

SimCorp BI Cloud

Sales module dependency

Data Warehouse Manager or Data Integration Layer for BI

Release 22.10 Data Warehouse

Two additional Vizlib Qlik extension bundles

Two additional Vizlib Qlik extension bundles, increasing the collaboration options and Financial reporting capabilities of SimCorp BI

• VizLib Finance Report. Allows for visualizing data in a professional P&L or Balance sheet. Fully customizable and enables both a professional look and feel as well as an extended range of options and customizations when visualizing tabular data.
• Vizlib Collaboration. Enables users to communicate with dashboards in context of the data and filters they are seeing and applying. Further enables writeback functionality for end users to input data through the dashboards, opening for a wide range of use cases. 

See generic examples below:

Caption: Finance Report example.

Caption: Collaboration example.

Subscription based licensing

SimCorp BI

Sales module dependency

Dependency on SimCorp BI Core

Release 22.01 Data Warehouse

Data Warehouse on Snowflake

This module enables SimCorp Data Warehouse to be deployed on Snowflake. For clients that want to run their reporting and analytics data on a native cloud data warehouse. Snowflake (a market leading Cloud RDBMS platform) has the unique capabilities of offering a data cloud service where they manage the overhead of maintaining platform as well as flexibility in offering a consumption-based usage model.

The SimCorp Cloud Data Warehouse is provided with an Investment Management Warehouse Model (IMW) which a best practice data model based on Ralph Kimball methodology. 

It allows clients to load data from SimCorp Dimension as well as external data sources. It’s easily extendible with new tables, new fields and adding additional data sources via the provided intuitive tool called Data Warehouse Manager.

Caption : Key features of SimCorp Cloud Data Warehouse (powered by Snowflake)

For our existing SimCorp Data Warehouse users, the user and dataflows are similar thus easily transferable to a Snowflake Cloud target.

For new users to SimCorp Data Warehouse, our cloud offering provides an intuitive interface i.e. Data Warehouse Manager for deploying our standard Investment Management Warehouse model as well as providing governance for structural changes such as adding new fields or new tables or new data sources.

Caption : Data Warehouse Manager – Target connection to Snowflake

The Investment Management Warehouse is available with the following content

Benefits

• Enables easy access to your investment data for reporting and analytics
• Optimizes your data landscape with a single view of truth for your data
• Reduces operational overhead and achieves a governed self-service environment to support your digital journey

Subscription based licensing

No subscription package. Pilot release 

Sales module dependency

Data Warehouse Manager for subscription clients.
Data Warehouse Manager
Investment Management Warehouse (and additional data subject areas)

Data Warehouse on SCDaaS (Powered by Snowflake)

This module enables the delivery of Cloud Data Warehouse as a Service.

For clients that want to run their reporting and analytics data on a native cloud data warehouse. Snowflake (a market leading Cloud RDBMS platform) has the unique capabilities of offering a data cloud service where they manage the overhead of maintaining platform as well as flexibility in offering a consumption-based usage model.

The SimCorp Cloud Data Warehouse is provided with an Investment Management Warehouse Model (IMW) which a best practice data model based on Ralph Kimball methodology. 

It allows clients to load data from SimCorp Dimension as well as external data sources. It’s easily extendible with new tables, new fields and adding additional data sources via the provided intuitive tool called Data Warehouse Manager.

Caption: Key features of SimCorp Cloud Data Warehouse (powered by Snowflake)

For our existing SimCorp Data Warehouse users, the user and dataflows are similar thus easily transferable to a Snowflake Cloud target.

For new users to SimCorp Data Warehouse, our cloud offering provides an intuitive interface i.e. Data Warehouse Manager for deploying our standard Investment Management Warehouse model as well as providing governance for structural changes such as adding new fields or new tables or new data sources.

Caption : Data Warehouse Manager – Target connection to Snowflake

The Investment Management Warehouse is available with the following content:

Benefits

• Fully managed Data Warehouse as a Service enables you to outsource the operation overhead of maintaining and managing the data warehouse
• Enables easy access to your investment data for reporting and analytics
• Optimizes your data landscape with a single view of truth for your data
• Achieves a governed self-service environment to support your digital journey

Subscription based licensing

No subscription package. Pilot release 

Sales module dependency

Data Warehouse Manager for subscription clients.
Data Warehouse Manager
Investment Management Warehouse (and additional data subject areas)

SFDR DWH Reporting

For -those not using the Data Warehouse Manager this module enables you to leverage our supported and maintained reporting structure for SFDR reporting. Then this restricted use Data Warehouse Manager allows you to build reports using the data provided in this structure and leverage the features of the DWH Manager for the sole purpose of SFDR reporting only.

This product covers the following 

• Use the permitted data subject areas of Strategic investment Analysis Data Subject area and specifically the Concentration Aggregation Results Fact table 
• Creation of data marts where data is sourced from the above subject area and fact table 
• Sourcing data from SimCorp Dimension for the purpose of supporting SFDR reporting 
• Extensions to Concentration Aggregation Results Fact table for the sole purpose of supporting SFDR reporting 

Benefits

• Standard Data Warehouse with reporting data content for SFDR reporting eliminates the need for clients to build custom extractions
• Enables faster implementation of SFDR reporting
• With add on modules, ability to extend Data Warehouse use to other data subject areas and consumers

Subscription based licensing

SFDR - Sustainable Finance Disclosure Regulation 

Sales module dependency

Data Warehouse Manager for subscription clients.
Data Warehouse Manager
Investment Management Warehouse
strategic investment analysis DSA
Standard Platform DSA
SFDR - Sustainable Finance Disclosure Regulation