Category Archives: SSAS

SQL Saturday May 2016, Jacksonville, FL

Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville.  I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely … Continue reading

Posted in Azure, Career, Performance Tuning, PowerBI, SQL Administration, SSAS, SSIS, SSRS | Leave a comment

Reading an SSAS cube thru SQL using MDX

Do you need the ability to read a cube, but you want to read it thru SQL?  And, why would you do this?  Well, for example, suppose you wanted to email the results of a certain MDX query…and you didn’t … Continue reading

Posted in SQL Administration, SSAS | Tagged , , , | Leave a comment

SSAS not logging?

So you’ve followed all the advice and set up logging so that you can know who is using your cubes.  Things are good.  One day you wake up and see that your logs no longer are logging.  You open your cube … Continue reading

Posted in SQL 2008, SSAS, SSRS | Tagged , | 1 Comment

Who’s been using your Cube?

To keep track of how many people are actually using the results of your hard work… You have two considerations: 1. Turn on Logging on your Analysis Services Cube 2. Actually query that log…

Posted in SQL 2008, SSAS | Tagged , , | Leave a comment

ASSP.dll…super great functionality

There is a “DLL” that you are going to want to install on your SSAS servers… it is called “ASSP.DLL”…and you can get it from Code plex.  To quote CodePlex: The Analysis Services Stored Procedure project is a set of … Continue reading

Posted in SSAS | Tagged , , | 1 Comment

Tools to help you when developing SSAS cubes

There are a number of available tools that are free

Posted in SSAS | Leave a comment

SSAS File organization

A few miscellaneous notes today on the location of various file when working with Analysis Services.

Posted in SSAS | 1 Comment