SQL Server 2008, formerly codenamed Katmai, was released on Augand goals to make data self organizing, management self-tuning, and self maintaining with the improvement of SQL Server Always On technologies, to give almost-zero downtime. The Microsoft Excel spreadsheet application can also be used to open these CUB files for offline analysis, which means users of Microsoft Windows-based systems with Excel 2010 can open and save these CUB files as offline cubes.
The PivotTable Service program is a component of the Microsoft SQL Server software, and it can be used to access the content of a CUB file. OLAP (Online Analytical Processing) can be performed using the data in these CUB files. Data schema details associated to the content of a CUB file are also stored in the corresponding CUB file. 'Cubes' are pieces of data stored by Analysis Services into a CUB file, and these 'cubes' are exported lines of data from sources used to store structured data. cub extension and are also called Analysis Services cube files. Microsoft developed the CUB format as data files created and referenced by Analysis Services. Analysis Services is a built-in component of the Microsoft SQL Server software, and this applet uses files stored in the CUB format.
