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
Tag: 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
Dealing with Power Pivot to Tabular Upgrade Errors
Upgrading from Power Pivot workbooks to SSAS Tabular models is usually a pretty seamless process. This is part of the beauty of the relationship between
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
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 – 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
SSAS – Changing the Dimension ALL Member Name
All Analysis Services dimensions have a default All member that represents all the members for a particular attribute. For example, let’s say you have a
SSAS – Preserve Measure Null Values
Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in measure data of a fact
Devin Knight 