• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

Connect a cube file with Excel to SQL Server

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 ?

Tks
BIServer.png
0
AXISHK
Asked:
AXISHK
  • 2
1 Solution
 
Jerry PaladinoCommented:
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.
Accessing-a-SQL-Server-OLAP-Cube.pdf
0
 
AXISHKAuthor Commented:
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.

Tks
0
 
Jerry PaladinoCommented:
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.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now