BIDS

WHITEPAPER

SSAS Tabular as Analytical Engine

This article describes pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it.

ARTICLE

Community Events in Köln (October) and Copenhagen November #ssas #tabular #powerpivot

Short update about community events in Europe where I will speak. On October 11 I will present DAX in Action in Köln – all details in the PASS local chapter here: http://www.sqlpass.de/Regionen/Deutschland/K%C3%B6lnBonnD%C3%BCsseldorf.aspx I will be speaking

ARTICLE

SSAS Tabular Workshop online and other upcoming dates (and updates!) #ssas #tabular

After many conferences and travels, this summer I had some time to write and prepare new sessions for the next wave of conferences. In reality I am just doing that, even if I already restarted traveling for consulting and training. So expect new content

ARTICLE

Change default workspace and deployment server in #Tabular #SSAS #Denali #CTP3

When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error: You cannot open the BIM

ARTICLE

Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot,

ARTICLE

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

ARTICLE

The Microsoft BI Roadmap: BISM, UDM and Beyond

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it

ARTICLE

DateTool dimension: an alternative Time Intelligence implementation

Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given

ARTICLE

DateTool dimension: an alternative Time Intelligence implementation

Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given that you might have a server-side feature doing that (so you don’t discriminate Excel

ARTICLE

BIDS Helper beta 0.9

BIDS Helper is an addin for Visual Studio that really improves productivity developing solutions for Analysis Services. Today I tested it and looking for its feature I encountered a page describing the “Show Extra Properties” feature… and it links a