22-25 April 2026

Building cubes from ODS or Operational Systems

2009

TL; DR

A step-by-step demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star/snowflake schema Data Warehouse/Mart first.

Session Details

A demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star schema Data Warehouse first.Targeted specifically at SSAS developers (those who have developed cubes on top of star/snowflake schema data mart/warehouse). DW architects would also be able to benefit/take away the idea as a new concept.

3 things you'll get out of this session