Category: Analysis Services

Clear Cache XMLA for SSAS Multidimensional

I often use the following XMLA code to clear database/cube/measure group cache in SSAS Multidimensional when I do performance testing between different MDX queries or versions of the same database. I am posting it here so that I can find it easily in future. You can use it to clear the cache at the database, cube or … Continue reading Clear Cache XMLA for SSAS Multidimensional

How to change the font size of the formula bar and measures grid in SSDT for SSAS Tabular

When you create a new measures in SQL Server Data Tools (SSDT) for SSAS Tabular, you edit the formula in the top section of the user interface in a section called "formula bar". The default font size for this formula bar is 8. The small font size may be difficult to read for some people. The easiest and fastest way to change the font … Continue reading How to change the font size of the formula bar and measures grid in SSDT for SSAS Tabular

MDX script keyword colors are back in SQL Server Data Tools (SSDT) release version for Visual Studio 2015

The MDX keywords in a cube script were not properly changing colors in the SQL Serve Data Tools (SSDT) Preview version for Visual Studio 2015. (14.0.60316.0). (See my previous post on this problem here.) The different keyword colors make it easier to write, organize and read an MDX script inside a cube. The following picture show Adventure … Continue reading MDX script keyword colors are back in SQL Server Data Tools (SSDT) release version for Visual Studio 2015

SQL Saturday #522 Jacksonville

Here is the slide deck for my session "A SQL Developer's Guide to MDX Basics" from SQL Saturday #522 in Jacksonville. A SQL Developer’s Guide to MDX Basics This session is targeted for those who have a good understanding of SQL language and are interested to learn how to write MDX queries against SQL Server … Continue reading SQL Saturday #522 Jacksonville

MDX keyword colors are missing in SQL Server Data Tools for Visual Studio 2015 Preview

MDX keywords are not changing color in the calculation script in SQL Server Data Tools - preview version for Visual Studio 2015. Hopefully this is a temporary issue and will be fixed in the release version. Having different keyword colors than the rest of the code makes it much easier to read, write and maintain the … Continue reading MDX keyword colors are missing in SQL Server Data Tools for Visual Studio 2015 Preview

Setting the slice for SSAS partitions

When SSAS 2005 came out the recommendation for setting the slice for MOLAP partitions changed. This is what the “SQL Server Best Practices Article” said: “For MOLAP partitions, you do not have to specify the slice because the server will be able to figure out the relevant partitions after the data has been processed.” Most … Continue reading Setting the slice for SSAS partitions