Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files. All measure groups by default
Category: SSAS
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted
MDX Time Calculations Built to Scale
When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS they likely have spent several
Understanding Analysis Services Relationships using Dimension Usage
As a part of designing an Analysis Services cube you must define how each dimension is related to each measure group in your cube through
Choosing the Right Analysis Services: MOLAP vs. Tabular Recording and Q&A
I hope you were able to attend my free webinar on Choosing the Right Analysis Services: MOLAP vs. Tabular on February 11, 2014 that I
SQL Server Analysis Services Webinar
Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire month of Back to Basics
OLAP PivotTable Extensions Update
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It allows you to have some
SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They give you the ability to
SSAS – Display Folders
Display folders are an often used tool in Analysis Services to help end users navigate through a cube or dimension they could find what they
SSAS – Deployment Wizard
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your environment. Often I see developers
SSAS – Understanding KeyColumns Dimension Property
For many Analysis Services developers building dimensions with many attributes and hierarchies is something that comes as second nature to them. However, I’ve found for
SSAS – Creating and Using a Writeback Measure Group
Imagine you have spent the last 9 months developing a sales Data Warehouse and an Analysis Services cube. Your end users love what you have
SSAS – Using Dimension OrderBy AttributeKey
Often when building dimensions there is a need to order you dimension attributes by something other than the NameColumn or KeyColumn properties. An example of
SSAS – Measures or Attributes in Multiple Display Folders
I had a client recently show me a neat little tip that I thought I would share. In the cube he was designing he had