Home / MSBI

Learn to Define Perspectives and Translations in SSAS

Rating: 4.0Blog-star
Views: 3026
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

 

 

About Author

author
NameRaunaak
Author Bio

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.