Browse by Tags

• MDX
• PowerPivot

• Gemini is now PowerPivot

  The project codenamed Gemini has an official name now: PowerPivot . The complete name should be “PowerPivot for Excel 2010”, but PowerPivot is simpler. I didn’t like that name yesterday, but today it seems better. Microsoft announced this name at the Read More... Posted Friday, October 23, 2009 3:59 AM by Marco Russo (SQLBI) | 6 Comments Filed under: Analysis Services, Excel, PivotTable, PowerPivot

• Excel 2007 PivotTable with calculated members

  Today I had a big trouble with one customer. We migrated an AS2000 solution to SSAS2005, making a lifting to dimensions just to consolidate into attributes what were indipendent dimensions in the old cube. One of the old dimensions contained only one Read More... Posted Wednesday, January 31, 2007 7:52 PM by Marco Russo (SQLBI) | 9 Comments Filed under: Analysis Services, Excel, PivotTable

• Display the MDX query of an Excel 2007 PivotTable

  Often end users use Excel to navigate into the cube. Then they may ask you to produce a report using the same data. It would be useful to get the MDX query used by Excel. Moreover, Excel 2007 offers a good MDX quality of the produced query against Analysis Read More... Posted Thursday, January 18, 2007 12:51 PM by Marco Russo (SQLBI) | 21 Comments Filed under: Analysis Services, Excel, MDX, PivotTable Attachment(s): ExcelMacroDisplayMdx-2007.zip