Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles. There is a … Continue reading →
Over the past few years I have developed a list of ways to improve performance in SSAS and in two of the tools that use it: ProClarity and PerformancePoint. Below are those performance tips along with other important items to be … Continue reading →
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to master than SQL. One trick I have learned is that instead of trying to write MDX from scratch, use one … Continue reading →