| Using SSAS 2005/2008 as PowerPivot Data Source: Query Designer |
| Written by Marco Russo |
| Tuesday, 24 August 2010 22:05 |
|
The query designer in PowerPivot has a few limitations that require the manual modification of the MDX query to get data that are often needed to create a PowerPivot model that compares data from cube with data from other sources (like Excel workbooks or external databases). For example, it is not possible to import the attribute key (the MDX query designer import just the attribute description). These limitations can be overcome by modifying the cube structure, but the point is that a well-designed cube following all the existing best practices results in a hard to use data source for PowerPivot, because it is not easy to import some data that are usually hidden in PivotTables, but important to create a model that relates data from different sources.
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
