Named Query & Named Calculation in SSAS

Rating: 5
Views: 5294
by Raunaak
Last modified: March 20th 2021

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 the data source view

If you would like to become an SSAS Certified professional, then visit Mindmajix - A Global online training platform: “ SSAS Certification Training Course ".This course will help you to achieve excellence in this domain.

Navigation:
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, the always better performance the query gives.

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

Explore SSAS Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 

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