Posts Tagged ‘SSAS’

Time Well Spent in 2015

The end of 2015 is fast approaching, with December looming just a week away. For most people, December is packed with the hustle and bustle of last-minute gift shopping, or end-of-year projections and budgets for 2016. Often in the sway of all this activity, many are so focused on the approaching New Year that they […]

How to install Tabular Mode Service in SSAS 2012

Introduction SSAS 2012 provides three different approaches for creating a business intelligence semantic model: tabular, multidimensional, and PowerPivot. Tabular solutions use relational modeling constructs such as tables and relationships for modeling data, and the xVelocity in-memory analytics engine for storing and calculating data. Multidimensional and data mining solutions use OLAP modeling constructs (cubes and dimensions) […]

Creating Dynamic OLAP cubes from Custom Field data, pt. 2

Last time, we discussed arriving at a BI/DW solution for the problem of source application “Custom Fields.” This time, I want to look at the OLAP design, and the mechanisms that make it work in Analysis Services.  As you may recall, we were working on designing a multi-tenant SaaS analytics application. Our greatest problem was in […]

Custom Fields original model

Creating Dynamic OLAP cubes from Custom Field data, pt. 1

A source system that contains dynamic or customer-defined data fields is both an old problem and a sticky one in the  DW/BI environment.  A standard approach of flattening the dynamic data into name/value pairs is recommended for a relational-type database.   But what about multidimensional modeling or OLAP storage?  Name/value pairs are just the beginning.  To […]

Additional SSAS Instance Installations in SQL Server 2012 (RC0)

Overview Please check out the other blogs in the series related to setting up each of the main SQL Server 2012 features. Links to each of the related blogs are shown below. Installation Order: SQL Server 2012 (RC0) Business Intelligence Configuration SQL Server 2012 (RC0) Installation and Configuration SharePoint 2010 Installation for SQL Server 2012 […]

SSAS Usage Statistic Dashboards

One of the most popular questions after an SSAS cube is moved into production and users begin accessing the data is, “Who’s using the cube?” It makes sense right? After spending a lot of time and money getting an analysis cube built, who wouldn’t want to know what the usage was like? Luckily, there is […]