THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Analysis Servic... » Excel   (RSS)
Showing page 2 of 2 (14 total posts)
  • Importing data from Analysis Services 2000/2005/2008 to PowerPivot

    In the next 2 to 3 weeks I will publish a few blog posts about importing data to PowerPivot using Analysis Services as a data source. This is something I studied a lot during the beta test of PowerPivot and it is not a topic that has a place in the upcoming book about PowerPivot I wrote with Alberto Ferrari. I will make a few considerations about ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 16, 2010
  • 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 Microsoft SharePoint Conference 2009 held in Las Vegas. As usual, demos are good and people are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 22, 2009
  • 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 ''dummy'' member, and a series of calculated members. With Excel 2003, you had no troubles ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 2007
  • 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 Services 2005 (much better than Excel 2003). I don't know why Excel doesn't have such a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 18, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement