Platinum Sponsor

Building cubes from ODS or Operational Systems

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.
Presented by Vincent Rainardi at SQLBits V
  • Downloads
    Slide deck available Slide Deck 200 KB
    Video available WMV Video 161 MB
    Samples available demos 2 KB
  • SpeakerBIO
    vincent_rainardi.jpg
    Vincent is a data warehouse & BI architect. He wrote a book on SQL Server data warehousing & BI, as well as many articles on www.datawarehouse.org.uk. Vincent is certified in designing BI solutions, database design and DBA (MCTS, MCITP, MCP).
    http://www.datawarehouse.org.uk/ http://www.datawarehouse.org.uk/feed/
  • Video
  • Session Files Explorer
    The network name cannot be found.