Tag: DAX

Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP

Microsoft demonstrated PowerView on top of the Multidimensional model in Analysis Services several weeks ago at SQL PASS and now the CTP version of the product is available here. There are two pieces of new functionality delivered with this CTP: Update for Analysis Services engine to allow DAX support for Multidimensional models Update for the

Continue reading

Dynamic security in a tabular model for analysis services

The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security.  In order to implement it, first we need the means of finding out the windows credentials of the user.  That can be accomplished using the DAX function USERNAME(). Second, we need to map

Continue reading

Microsoft SQL Server 2012 Virtual Labs

Microsoft has posted 16 virtual labs online. The labs cover three major areas: Business Intelligence Mission Critical Operations Database Management Those of us who are trying to jump start Self Service BI in our organizations should checkout the following three: Creating a PowerPivot Model and Report in the Excel Client Defining DAX Calculations with Microsoft

Continue reading

Parent Child in PowerPivot

Kasper de Jonge posted a great article about building PowerPivot hierarchies against dimension tables that implement parent/child relatioship… Basically, a new PATH() DAX function is used to build a string that contains a path from the leaf to the top parent level member in the hierarchy and then a PathItem() function is used for each

Continue reading