| Using SSAS 2005/2008 as PowerPivot Data Source: Direct MDX |
| Written by Marco Russo |
| Sunday, 29 August 2010 23:47 |
|
If you write direct MDX queries using SSAS 2005/2008 as a PowerPivot data source, it is better if you prepare your MDX query by using another editor. For example, write and test your MDX query by using SQL Server Management Studio and then copy & paste your query into the user interface provided by the Table Import Wizard. The remaining part of this post is dedicated to an explanation of the reasons for that.
|
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?
