Topic: PivotTable

        9 posts
blog post –

Difference between DISTINCT and VALUES in DAX

I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name  Read more

blog post –

Varigence Vivid and Bonavista Dimensions

Yesterday Chris blogged about Varigence Vivid and Bonavista Dimensions . His post remembered me that I might share my comments about Vivid and I had to take a tour around Bonavista Dimensions, and here we are. Varigence Vivid is simply something that  Read more

blog post –

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

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