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


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 databse 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 , when ever we want to represent the high level and important business information in Graphical items .    

                              
Ex: of Graphical items:

GUAGE
RESERVED GUAGE
THERMOMETER
FACTS
VARIENCE 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.


Enroll for Live Instructor Led MSBI TRAINING


RELATED COURSES

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