Overview: An offline cube allows one to save a local copy of an existing cube. This can be useful when one needs to access the cubes without connecting to OLAP database directly. This article will walk you through an example of creating an offline cube using the built in Excel functionality and pragmatically using the Analysis Services Query Editor. Process: Permissions: Before an end user can create an offline cube they must be either: 1.
An admin on the Analysis Services Server. Granted local cube permissions. Granting Local Cube Permissions to a User 1. Open the Jet Data Manager, open the project, right click the OLAP database, and navigate to OLAP Server User Rights. The OLAP Access Control window will appear. Click on the Cubes node and set the permission Read with Drillthrough and Local Cube. In this example we are giving users of our Sales Team role permission to create an offline cube for our Sales cube only.
In order for the date dimension to work with Excels offline cube functionality we suggest only selecting the Date YQMD user defined hierarchy (as opposed to the individual Month, Quarter, and Year levels). If you do select the individual Month, Quarter and Year levels you may be presented with the following error: 6. Chose the members that you want to see for the dimension level chosen in step 5.
To my Analysis Services server, it creates the cube. A local cube file is. Apr 27, 2010 - I discovered that you can actually just send the offline cube file (the. Bishop Dress Pdf Pattern Free. cub) to another user and they can open this cube file directly from excel. Nov 21, 2014 - Open the SSMS(SQL Server Management Studio); Connect the Analysis Service database; Right Click the selected database and select New MDX query; Write the query logic to create for offline cubes. Example MDX query for Offline cube creation with Adventure Works database: [MDX] CREATE GLOBAL. Sep 17, 2012 Local cube files.cub cannot be. I have several local.cub files created in excel 2003. MS OLE DB Provider for.
In this example we selected every member (ticked every box) in the list. Select the location to which you wish to save the.cub file. Click Finish.
This process may take a considerable amount of time depending on the size of the cube data source and the environment being used. You can now open the file using Excel.
Analysis Services Query Editor: Sometimes the built in Excel functionality may not work properly, or you may need to expand the offline cube functionality. To do this we will need to build a query to create our offline cube. Open SQL Server Management Studio and connect to Analysis Services. Right click your OLAP database, New Query, and MDX. A syntax example is provided below that can be used as a basic template.
This example creates an offline cube called Sales Cube Offline, saves the file to the C drive, and uses all the dimensions and measures listed between the parenthesis.