Friday, February 19, 2016

SSAS multidimensional data cubes with hierarchal data (Bill of Materials)

This is a SSAS multidimensional data cube with hierarchical data (Bill of Materials).  Even though this link goes through the process of building this SSAS cube for SAP R3, I believe there is something here to be gleaned in building your own similar BI cubes for your non-SAP ERP system.

https://biwithjb.wordpress.com/2011/05/23/bom-bill-of-materials-scenarios-with-sql-server-analysis-services-2008-r2/

Visibility ERP blob site link