Mindmajix

Named Query & Named Calculation in SSAS

Named Query

These queries are helpful to construct a table with 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:

Screenshot_110

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

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

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

Navigation:

Screenshot_111

Enroll for Instructor Led Live Online MSBI Training


 

0 Responses on Named Query & Named Calculation in SSAS"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.