Home  >  Blog  >   MSBI  > 

Named Query & Named Calculation in SSAS

Rating: 5
  
 
5557
  1. Share:
MSBI Articles

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.

 MindMajix YouTube Channel

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

 

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
MSBI TrainingMay 23 to Jun 07
MSBI TrainingMay 28 to Jun 12
MSBI TrainingMay 30 to Jun 14
MSBI TrainingJun 04 to Jun 19
Last updated: 12 Apr 2022
About Author
Raunaak

As a content writer and storyteller, Raunaak Mitra regards himself to be a prodigy in writing. He firmly believes that language is borderless, and anyone can write as long as they have a strong narrative capability and the ability to emote feelings into words. Authors like F. Scott Fitzgerald and R. K. Narayan have influenced him to keep the writing as simple as possible for anyone to understand. Other than being well-versed about technological trends like AI, Machine Learning, AR, VR, Gaming, Microprocessors, Cloud Computing, Industry 4.0, literally any technological advancement (old or new), he also shares a knack to curate fiction on sci-fi, satire, and thriller genres.

Recommended Courses

1 /15