You searched "BISM"
       Page 7 of 72 blog posts
blog post –

First steps with #ssas #Tabular in #Denali #CTP3

The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and acronyms  Read more

blog post –

#MDX in London and speculation about future books

Chris Webb, who wrote the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book with me and Alberto , is preparing another Introduction to MDX course in London, this time from October 26th to 28th. It is now a three day course  Read more

blog post –

Strange date relationships with #PowerPivot

A reader of my PowerPivot book highlighted a strange behavior of the relationship between a datetime column and a Calendar table. Long story short: it seems that PowerPivot automatically round the date to the “neareast day”, but instead of simply removing  Read more

blog post –

PowerPivot, basket analysis and the hidden many to many

Surfing on the web, here , I came into this intriguing question: How do we ask something like “Show me how many customers have an iPad but don’t have a book?” We are speaking about a sales analysis where the canonical entities are Customers, Products  Read more

blog post –

PowerPivot: improve the performances by sorting tables

While it is well know that in UDM data should be loaded sorted, to get better file compression and map structures. The world of PowerPivot (and BISM) is yet not explored. Working with a 50 millions rows table, I tested various scenarios to check if sorting  Read more

blog post –

SQL Pass meeting in Zurich after #powerpivot workshop #ppws

These are the last days to register for the PowerPivot Workshop in Zurich on April 4-5, 2011. If you are willing to attend, hurry up! Moreover, on Thursday evening there will be also a Swiss PASS Chapter meeting in Zurich and Alberto Ferrari will present  Read more

blog post –

User Group meeting in Copenhagen for #powerpivot

The next Monday, March 21st, I will join a special event organized by the Danish SQL Server User Group , Excelbi.dk and the Swedish SQL Server User Group . The meeting will start at 18:00 at the Radisson Royal Blu in Copenhagen, and this is the topic  Read more