Wednesday, September 30, 2015

Attributes in SSAS



In Microsoft SQL Server Analysis Services, attributes within a dimension are always related either directly or indirectly to the key attribute. When you define a dimension based on a star schema, which is where all dimension attributes are derived from the same relational table, an attribute relationship is automatically defined between the key attribute and each non-key attribute of the dimension. When you define a dimension based on a snowflake schema, which is where dimension attributes are derived from multiple related tables, an attribute relationship is automatically defined as follows:
·         Between the key attribute and each non-key attribute bound to columns in the main dimension table.
·         Between the key attribute and the attribute bound to the foreign key in the secondary table that links the underlying dimension tables.
·         Between the attribute bound to foreign key in the secondary table and each non-key attribute bound to columns from the secondary table.














Keyword: SSAS Interview Questions,SSAS interview and SSAS Interview Part 1, Interview Questions for SQL Server Analysis Services

No comments:

Post a Comment