Initial Attributes and Measures in SSAS Multidimensional Cubes
Connecting to tables in SQL Server Analysis Service (SSAS) databases is easy. Maybe too easy. The learning curve for developing in a Multidimensional Cube is steep, although a Tabular Model has lessened this curve. The power of encapsulating the business logic of aggregations and analytics into an Analysis Service database is too great not to embrace Analysis Services in an enterprise environment.
The steps for connecting to a table are different between Multidimensional Cubes and Tabular Models. But, they both can use the same optimization techniques. A different tactic must be taken. Cubes separate the dimension tables from the fact tables. The Tabular Model imports or connects to a dimension table just like a fact table.
Tags: design