Menu
In Excel pivot table you can request the generation of a offline OLAP cube : i.e., a file with the .cub extension. Does anybody know or have any pointer about this file format ?
Thanks, _marc
318
The Offline OLAP feature basically snapshots a version of the cube into a local cube file which can be used by Pivot Tables.
Data file created by Analysis Services, a component of Microsoft SQL Server; stores a "cube," which is a collection of structured data exported from a data source; includes the data schema as well as the data itself; often used for performing Online Analytical Processing (OLAP) analysis.
These cubes are stored in SQL Server Analysis Services (SSAS). Self-service business intelligence tools such as Excel and SQL Server Reporting Services (SSRS) can target these cubes in SSAS, and you can use them to analyze the data from multiple perspectives.
cub file rather than open it directly via File > Open. Please try going to Insert > PivotTable, select Use an external data source, click Choose Connection, hit Browse for More..., choose the . cub file: Hope the above information can be helpful.
I think all of the information you need to create them is here, but according to this post, you can only edit them with SSMS.
EDIT: A C#-only approach is laid out here.
68
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
