6

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

Marc Polizzi
  • 9,275
  • 3
  • 36
  • 61

2 Answers2

1

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.

Chris Shain
  • 50,833
  • 6
  • 93
  • 125
  • Unfortunately, I cannot use any MS tool for the task; I would need to create the files from scratch. – Marc Polizzi Jan 13 '11 at 23:35
  • See my edit above- you can do it in C# with XMLA. I think that's as close as you are likely to get, but if C# counts as a 'MS tool' you might be out of luck. – Chris Shain Jan 14 '11 at 00:36
  • C# / XMLA would be nice if the actual job to create the cube file was not performed by the ADOMD.NET driver. The XMLA file does not help to understand the actual file format. Thanks for the info anyway. – Marc Polizzi Jan 14 '11 at 12:37
  • Accepted as it seems there's no spec. out there and MS only tools allows for that. – Marc Polizzi Jun 15 '12 at 09:21
1

Here you can find how to transform xmla to .cub. If your task is to generate cub files from your application, it can be a good solution. There is much more information on xmla (standard) format than on proprietary .cub. Xmla is a standard and there are opensource implementations - olap4j, mondrian.

Skarab
  • 6,981
  • 13
  • 48
  • 86
  • I have found this website, It looks like a good start. I hope it helps - http://www.cubeslice.com/infocntr.htm. – Skarab Jan 19 '11 at 17:15