I found projects for later versions at -server-samples/releases/tag/adventureworks-analysis-services and I (not knowing anything about designing, deploying and processing a cube) actually managed to deploy and process a cube, but I had to edit the cube XML (basically I commented out some statements that referred to years greater than 2008).
The Adventure Works OLTP Data Warehouse is the relational database that serves as the source of data for our cube. This is our sample data. This can be downloaded as a SQL Server backup file from the Adventure Works download site, named Adventure Works DW 2014 Full Database Backup.zip.
Download Adventureworks 2012 Cube
The Adventure Works Analysis Services SSDT Project files are the Visual Studio project files which were used to build the Adventure Works cubes. These can be used to make changes to the structure of the Adventure Works cube and rebuild it. The project files can be downloaded from the Adventure Works download site, named AW Multidimensional Models SQL Server 2014.zip. As with the Multidimensional full backup files, two versions (Standard and Enterprise) are contained within.
The cube database that you will create in this tutorial is a simplified version of the Analysis Services multidimensional model project that is part of the Adventure Works sample databases available for download on GitHub.
These downloads are scripts and full database backups (.bak) files that you can use to install the AdventureWorks (OLTP) and AdventureWorksDW (data warehouse) sample databases to your SQL Server instance. Note that AdventureWorks has not seen any significant changes since the 2012 version.
You can connect to various data sources such as Microsoft SQL Server Analysis Services (SSAS), or online cubes, or attach to a local cube at runtime. FlexPivot control works with Analysis Services and SQL Server 2008, 2012 and 2014.
2ff7e9595c
Comments