Cognitive Information

SSAS Lost security context

SSAS lost security context in the domain and is showing SID’s in the Security properties. How to fix it.

SSAS Tabular Error “The object reference not set to an instance of an object”

SSAS Tabular Error “The object reference not set to an instance of an object” means you need to check all the columns in your tabular model.

SSAS Cube Partition Slice ErrorCode=”3240034361″

f you ever get the following errors when processing cubes, it has to do with the Slicer property at the cube partition level. Error ErrorCode=”3240034361″ Description=”Errors in the OLAP storage engine:
The restrictions imposed on partition slice where violated.” Source=”Microsoft SQL Server 2012 Analysis Services”

Sharing SQL 2012 data in SharePoint 2013

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a ‘List’ using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.

How to fix “Usage Based Optimizer” connection errors in SSAS 2012

The Usage-Based Optimizer can be a very powerful tool for calculating aggregations, when it works. When it doesn’t work perfectly, then it can be frustrating to figure out. The devil is in the details. If you move data between environment, then you have even more details to find and fix.

SQL Rally 2012 BI Track Highlights

PASS SQL Rally in Dallas, TX had some great speakers. Here is my list of some great sessions on the business intelligence track of the conference.

Using SQL to Build MDX parameters

I had a client report which needed a parameter list to default to the previous closed financial period date. The SSAS cube includes reporting periods into the future which have data entries even if the month has not been ‘closed’ by accounting department. Without a ‘Month Closed’ flag in the cube, the only way to […]

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: