BI on your terms with SQL Server 2016
The last few years Microsoft’s strategy was all about cloud first (or cloud only?), releasing new BI products and updates
Tag: Analysis Services Dimensional
Implement SSAS MD cell security using dimension security with blazing performance
SQL Server Analysis Services (SSAS) Multidimensional (MD) is a great product, and in my opinion it’s still the only real
Will SSAS, Cubes and MDX be abandoned because of the BI Semantic Model?
At the PASS Summit that is happening in Seattle at the moment Microsoft announced the “BI Semantic Model” (BISM). It
SSAS – Speed up dimensions using a NULL default cube measure
Recently I faced some problems with the performance of SSAS dimensions. The cube users were using a large dimension with
SSAS – MOLAP, ROLAP and HOLAP storage types
A big advantage of a BI solution is the existence of a cube. Data and aggregations are stored in a
SSAS – Visualize Attribute Relationships
Complicated attribute relationships are difficult to oversee in SSAS 2005. Microsoft solved this problem in SQL Server 2008 with a
Jorg Klein's Blog 