When I need to display data from a cube on a web page, I usually store the MDX query in a text file and make this file part of a resource file. This allows me to store the MDX in a readable format. In the image below, I have two files in the App_GlobalResources folder. The first [...]
SSAS
Powershell – Processing Production SSAS Databases
In an earlier post I demonstrated a method I use to update development SSAS databases using powershell. While this is okay for development servers it doesn’t really work with production boxes containing millions of rows of data. Generally when I refresh a cube, the only data that will have changed relates to the most recent month or [...]
HideMemberIf
Generally, when I want to create an unbalanced hierarchy I will use a parent-child relationship. The image below shows a basic parent-child hierarchy and the data within the dimension. Sometimes a parent-child relationship is not an option. In SSAS a dimension will only support a single parent-child hierarchy and I have come across a few situations where [...]
