Connect a cube file with Excel to SQL Server

Posted on 2014-02-19
Medium Priority
Last Modified: 2014-02-22
I need to maintain a excel connecting a cube file on SQL Server. What's its difference from a cube created in SQL Server. How to create this file. Is there a simple example to show how it works ?

Question by:AXISHK
  • 2
LVL 16

Expert Comment

by:Jerry Paladino
ID: 39870072
In my workplace, Excel is the User Interface to extract data and create reports from a SQL Server OLAP Cube.  The steps and screenshots from within Excel (2010) are listed in the attached PDF.   The results of these steps is an Excel Pivot Table where you can select the Measures and Dimensions from the Cube to create the pivot table report.

Author Comment

ID: 39870514
Tks. How to build this "cube file" on the SQL 2008 server. I have some idea for Analysis server on the SQL server but I can't find the cube. I believe the cube file is built in some other way.

LVL 16

Accepted Solution

Jerry Paladino earned 2000 total points
ID: 39870705
I thought your question was related to maintaining an Excel file attached to a Cube for reporting...   If you are asking how to build an OLAP cube you you may want to read this article and watch the embeded video. Defining and Deploying a Cube (SQL Server Video).  

This document is only a place to start..  Building an OLAP Cube in SQL Server is a complex process which I am not qualified to guide you through.   I can help with the Excel and reporting side but not building an OLAP Cube.

Thank You.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes a serious pitfall that can happen when deleting shapes using VBA.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question