You searched "Excel"
        Page 5 of 313 results
blog post –

Do more with less: the missing feature in Excel Services

A little background: in these days I’m preparing sessions for some upcoming conferences in Italy (despite the English titles, most of the sessions will be in Italian: Microsoft SharePoint & Office Conference 2010 next week and Microsoft SQL Server  Read more

blog post –

Memory Considerations about PowerPivot for Excel

PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made using Excel 2010. The SSAS engine is loaded in-memory in the process of Excel. Especially with  Read more

blog post –

SSAS 2008 calculated members still don’t love Excel 2007

I was tempted to start this post by this sentence “Analysis Services 2008 is not a new full release of SSAS” but as you can see, I resisted to it! :) Ok, it’s a joke. However, how do you interpret the answer “In the next full release of SSAS” when I asked  Read more

blog post –

Compatibility Checker for Excel Services

I just found this useful Add-In for Excel 2007 that checks the compatibility of a spreadsheet for Excel Services publication. I’d like to get feedback if you know other similar tools and/or if you have experience with this one.  Read more

blog post –

An useful guide to Excel 2007 Pivot Table

I found an interesting “how-to” guide to Excel 2007 Pivot Table. It is a sample chapter from the Pivot Table Data Crunching for Microsoft Office Excel 2007 book. Probably not all the described feature are available in a Pivot Table attached to an Analysis  Read more

blog post –

SSAS 2005 SP2 breaks Excel calculated member selection

After many tries, today I came to the conclusion that Analysis Services 2005 SP2 breaks the Excel 2007 calculated member selection feature. I already talked about this issue here , but today I found the way to reproduce the error. This is a scenario that  Read more

blog post –

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

blog post –

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

blog post –

Data Mining Addin for Excel

My experience with the term “add-in” was that you have a piece of software put on top of a bigger software, just to enable some little functionality. Today at SQL Pass 2006 I’ve seen how this term has to be redefined. The Data Mining Add-ins for Office  Read more