SSAS: What is Named Query?

1. Named Query is a SQL Statements and it act as a another table

2. It is formed by selecting rows and columns from single tables or relating multiple tables

3. It helps to make the data source view with new table structure without modifying the underlying data source

SSAS: What is Linked Dimension ?

In SQL Server Analysis Services (SSAS), Linked Dimension is a dimension which is existed in other analysis services DB. It may exist in same or different server. it helps the user to keep the common dimension in multiple database.