How to get .cub file

How to get .cub file

• Albin Julius

  AMO (Analysis Management Objects, the object model for administering AS2005, the successor for DSO from AS2000) also works with local cube files (.cub). You can use it to create/alter objects or to refresh the data by re-processing every night, as you mentioned.

  Sample code to connect to a local cube file:

  using Microsoft.AnalysisServices; // the .dll is in "%ProgramFiles%\Microsoft SQL Server\90\SDK\Assemblies", also in GAC

  ...

  Server server = new Server();

  server.Connect(@"Data Source=c:\MyLocalCube.cub"); // this will create an empty local cube if not there already

  ... // do something, for example process cubes

  server.Disconnect();

  
  

• FrankSh

  how can you do that...can anyone tell step by step
  
  

• Gregfmorgan

  You can create a .cub file when you make an offline copy of your cube with excel.

  /Dirk

  
  

• hande

  Dirk is right, if you want to create a local cube, you can use Excel, and select the cube you created and deployed.

  Yan

  
  

• basim_shanyour

  There are several tools out there which can help you create a .cub file as well (Cube Slice 9 for example). The wizard in Cube Slice is good and options are helpful.

  You can also do this using MDX like the below example. We rebuild our .cub files every night, using a loop to process the below MDX for each field rep.

  HTH ...

  ~Shari

  CREATE GLOBAL CUBE [MyTestCubFile]
  STORAGE '\\yourServer\OfflineReports\FieldRepName\MyTestCubFile.cub'
  FROM [Cube Name]
  (
  MEASURE [Cube Name].[Financial Transaction Amount],
  MEASURE [Cube Name].[Maximum Last Donation Date],
  DIMENSION [Cube Name].[Account].[Account Number]
  ( LEVEL [Account Number],
  MEMBER [Account].[Field Representative].[Field Rep Name goes here]),
  DIMENSION [Cube Name].[Distribution].[Financial Entity]
  ( LEVEL [Financial Entity]),
  DIMENSION [Cube Name].[Distribution].[Fund Name]
  ( LEVEL [Fund Name]),
  DIMENSION [Cube Name].[Distribution].[Fund Code]
  ( LEVEL [Fund Code]),
  DIMENSION [Cube Name].[Financial Transaction Apply Date].[Calendar Year]
  ( LEVEL [Calendar Year]),
  DIMENSION [Cube Name].[Financial Transaction Apply Date].[Fiscal Year]
  ( LEVEL [Fiscal Year]),
  DIMENSION [Cube Name].[Financial Transaction Apply Date].[Month Name]
  ( LEVEL [Month Name]),
  DIMENSION [Cube Name].[Transaction Method]
  ( LEVEL [Transaction Method]),
  DIMENSION [Cube Name].[Account Company].[Activity Level]
  ( LEVEL [Activity Level],
  MEMBER [Account Company].[Activity Level].[Donor] )
  )
  
  

• Kenny Voon

  Once you create the cube, you should have the .cube file in your project folder. Not the .cube folder.

  Yan

  
  
• How to get .cub file