Home / MSBI

Learn to Define Perspectives and Translations in SSAS

Rating: 4
Views: 3003
by Raunaak
Last modified: March 20th 2021

PERSPECTIVES

–> It is helpful to provide limited visibility to cube objects.
–> In this case, what are all the dimensions, fact, KPI's, calculations ….etc
You want to provide visibility to the user's take in perspectives.
–> New the user sees only the selected dimension facts, KPI’s calculations.
Navigation:
PERSPECTIVE –> NEW PERSPECTIVE –> CHANGE PERSPECTIVE NAME, CHECK (or) UNCHECK  the required objects and items.
                Eg:
 Navigation
Build –> Deploy –> Go to cube browser –> change the perspective and see the limited items (or) objects. 
Note: To provide  2 fact tables and only 5 dimensions visibility to a particular user in the cube of the five fact tables and 50 dimensions perspective are useful.

If you would like to become a 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.

TRANSLATIONS

This is helpful to provide multi-language support.
–> In 2000 the translation and multi-language support provided at the web page level.
But from 2005 onwards this support is at the BIDS level.
Navigation:
TRANSLATION –> NEW TRANSLATION –> SELECT LANGUAGE TELUGU (INDIA) –> CLICK OK
Eg:          OBJECT                                 DESCRIPTION
TEXT FACT                           VILUVALA PATTIKA
ACTUAL COST                    ASALU DHARA
ESTIMATED COST             COCTINCHINA DHARA ETC.
Build –> Deploy –> Go To browser –> and change the language to select Telugu –> see the results.
Build –> Deploy: If the cube structure changes in BIDS level, to effect the same in cube database level.
Build –> Process (Processing data):
The data (or) structure in the data sources changed, to effect the same in cube database.
 Key Performance Indicator
KPI (Key Performance Indicator)

–> These are the important business information representations.
–> Generally we go for KPI, whenever we want to represent the high level and important business information in Graphical items.    

Checkout SSAS Interview Questions

                              
Ex: of Graphical items:

GUAGE
RESERVED GUAGE
THERMOMETER
FACTS
VARIANCE ARROWS etc……


Standard Arrows :
 Standard Arrows
TRAFFIC SIGNAL       NUMERIC
RED       –>    -1
YELLOW    –>    0
GREEN     –>    1
Eg:   Display in Red color, If the actual cost is greater than (>) estimated cost.
Display in Green color, If the actual cost is less than (<) estimated cost.
Display in Yellow color, If both are equal in a graphical item traffic signal.

Navigation

KPI –> New KPI –>
Name: Sales_KPI
ASSOCIATED MEASURE GROUP: Text.Fact
VALUE EXPRESSION: [MEASURE] . [ACTUAL COST]
GOAL EXPRESSION: [MEASURE] . [ESTIMATED COST]
STATUS
STATUS INDICATOR: TRAFFIC LIGHT
STATUS EXPRESSION:
CASE
WHEN [MEASURES . [ACTUAL COST] – [MEASURES] . [ESTIMATED COST] > 0 then -1
WHEN [MEASURES . [ACTUAL COST] – [MEASURES] . [ESTIMATED COST] < 0 then  1
WHEN [MEASURES . [ACTUAL COST] – [MEASURES] . [ESTIMATED COST] = 0 then  0
END
TREND INDICATOR: Standard Arrow
TREND EXPRESSION: < same as status Expression >
Build –> Deploy
Go To ‘KPI BROWSER VIEW’ and then see the result.

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