Browse by Tags

• Analysis Services
• MDX
• Microsoftsoft BI Conference
• PivotTable
• SSAS

• Microsoft BI Conference 2008 - announcements on stage

  We’ve seen it on stage. It’s Excel on the steroids. I’m talking about “big announcement” here at Microsoft Business Intelligence Conference. The several announcements are: · Madison: the announcement of integration between SQL Server and DATAllegro, release Read More... Posted Monday, October 06, 2008 8:50 PM by Marco Russo (SQLBI) | 13 Comments Filed under: SSAS, Excel, Microsoftsoft BI Conference

• 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) | 3 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) | 5 Comments Filed under: Analysis Services, MDX, Excel, PivotTable Attachment(s): ExcelMacroDisplayMdx-2007.zip