SSAS Sorting Attribute Member by Secondary Attribute

Josh,

So you have an attribute like Month that contains values of "January", "February", etc.  By default this attribute will sort by text order, but this can be changed to sort off another attribute (i.e. Month Value).

SSAS Dynamic Prior Period

Josh,

When using the prior period function and you want the calculation to work on any level of the hierarchy, you'll need to remember the "CurrentMember.Level" syntax:

SSAS Binding Too Small

Josh,

So you've updated some tables used in a cube by increasing a column's length.  When you go to process the cube you are getting an error like "Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated."

Seems easy enough, right?  You just need to increase the Dimension Attribute's length.  Make sure you do it for both the NameColumn and KeyColumns sections:

Thanks to http://shahfaisalmuhammed.blogspot.com/2012/03/size-specified-for-binding-too-small.html