Named Query & Named Calculation in SSAS

• (5.0)

• | 1589 Ratings |

• Last Updated March 12, 2017

Named Query

These queries are helpful to construct a table with a customized query. Here advantages are
a) Restriction of rows and columns
b) Multiple columns form multiple tables

•  The name of the query result a cls like a tablenc
•  This option available in data source view.

Navigation:

Data source: DS_textfiles1 (primary)
Query : SELECT E.EID, E. E NAME, E. DLD,
D.DID, D.DNAME
FROM EMPE
INNER JOIN DEPT D ON D.DID=D.D
                  ↓
OK
Now connect this resulted table to the cube

Checkout SSAS Interview 

Named Calculation

• Like named queries, named calculations will also improve performance [be cause both run at source level]
• It is recommended in real time that if we are using a calculated value on permaneul calculations
• Instead of doing calculations at cube level, if the calculations are at the source level, always better performance the query gives.

Ex:- Creating Actual cost increment field, by increasing 12% of actual cost
Navigation:
                              

 

List of Related Microsoft Certification Courses:

SSIS	Power BI
SSRS	SQL Server
SCCM	SQL Server DBA
SharePoint	BizTalk Server
Team Foundation Server	BizTalk Server Administrator