Cognitive Information

Archive for SSAS

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”

Business Intelligence Forecasting in SQL and Cognos

Note: This article is an update of a presentation given when I was at the University of Oklahoma’s Health Sciences Center. At that time, I was using Cognos version 7.3. This article is updated for Cognos 10 and SQL Server Analysis Server 2012.  Revisiting this subject ten years later, my opinion is that Microsoft has […]

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: