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.
- Downloads
- SpeakerBIO
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).
- Video
- Session Files Explorer
Building_cubes_from_ODS_or_Operational_Systems
Building cubes from ODS or Operational Systems - Vincent Rainardi
Building cubes from ODS or Operational Systems - Vincent Rainardi.pptx
Building cubes from ODS or Operational Systems - Vincent Rainardi.zip
| |
0