Database Reference
In-Depth Information
Connecting Excel to the FirstCube cube
In my examples, I will use Excel 2013 Professional, as this contains some features
that are very interesting to users who wish to use Excel as their query tool.
To use Excel as the query tool against the cube, follow the given steps:
1. Open up Excel and create a new empty workbook.
2. Go to the tab named
Data
and click on the
From Other Sources
button to
create a connection to Analysis Services. Click on the
From Analysis Ser-
vices
button.
3. In the
Connect to Database Server
dialog, type the name of the server and
instance; if you have followed in this topic when installing the server it should
be
localhost\multidimensional
. Then click on
Next
.
4. Choose the
FirstCube
database and click on
Finish
.
5. Choose to create a
PivotTable Report
and click on
OK
. Now you have an
empty OLAP PivotTable connected to the
FirstCube
database and the
Ad-
venture Works DW2012
cube.
6. In the
PivotTable Field list
, drag the
Sales Amount
measure and drop it in
the
Values
field.
7. Drag the
Product Hierarchy
and drop it in the
Rows
field.
8. Drag the
Order Date Hierarchy
and drop it in the
Columns
field.
Now you have created a very simple report against your cube without writing one
single line of MDX. This shows the power of Analysis Services and multidimensional
model; an end user can create a lot of reports without the knowledge of how to write
code. The same code would actually look something like the following query:
Search WWH ::
Custom Search