Blog

  • Home
  • MSBI
  • Named Query & Named Calculation in SSAS

Named Query & Named Calculation in SSAS

  • (5.0)
  • | 2933 Ratings

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.
Enhance your IT skills and proficiency by taking up the SSAS Training.

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

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

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

List of Related Microsoft Certification Courses:



Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.


DMCA.com Protection Status

Close
Close