Blog

Learn to Define Perspectives and Translations in SSAS

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 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:
 
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.

Enhance your IT skills and proficiency by taking up the SSAS Training.

TRANSLATIONS

This is helpful to provide multi languages support.
–> In 2000 the translation and multi-language support provided at web page level.
But from 2005 onwards this support is at 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.
 
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 :
 
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!

 


RELATED COURSES

Get Updates on Tech posts, Interview & Certification questions and training schedules