Category SSAS

Deploying Tabular models

1 Introduction The purpose of this document is to document a viable way to deploy tabular models from say development to test to production. The lifecycle of a tabular project can be illustrated as follows : 2 Development All development of tabular models happens with Visual Studio where the developer uses a local instance as […]

Speaking at SQL Saturday Slovenia #356 – SharePoint as a BI platform

In only 10 days it is time for gathering of SQL Family and friends in Ljubjana, Slovenia. I will be presenting a brand new session that I’ve been working on for the last 3 years ! No kidding !! And just to make sure that I’m super fresh, I’ve been given the first morning session. […]

SSAS Basic at SQL Saturday 341 Porto

SSAS Basics pre-conference day I have the immense honor and privilege to have been selected to do a whole day of preconference on thursday October 16th at SQL Saturday Porto – Rua Dr. António Bernardino de Almeida. During this whole day of training I will give a thorough introduction to SQL Server Analysis Services together […]

From Hellhound to Best of Breed – A Guide To Setting up Kerberos Delegation with SharePoint BI Stack – Part I

This post is the first one in a series about using SharePoint BI features together with Kerberos, hereby enabling you to delegate the user credentials all the way to the data source, enabling role based security. When I think about it seems like people love to fear Kerberos. Often, the developers and the infrastructure people […]

See Beyond The Numbers: Data Visualization with Status Lists in Sharepoint 2010 – part 2 SSAS based Status Indicator and Fixed Value based Status Indicator

In part 1 of this post I wrote about first two types of Status Indicators : Sharepoint List based and Excel based. In this part I will demonstrate what the possibilities are for building Status List Indicators with SSAS KPIs and also with Fixed Values. SQL Server Analysis Services based Status Indicator This is a […]