Prototyping a cube with data from excel worksheet - before investing the time for ETL?


  • In the beginning with a new Data warehouse, you have no data in your database and no ETL working yet.  Im starting to build one of the first cubes and was wondering if I could save time by prototyping the cube with data in excel.  How would this work?

    I mean, you have your datasource, datasource view and your underlying database.  Where would the excel data fit into the picture?  Create another datasource with the same structure as your OLAP schema?

    Anyone got a link that explains something like this?

    Thursday, September 26, 2013 5:58 PM