Learn to Define Perspectives and Translations in SSAS
–> 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.
PERSPECTIVE –> NEW PERSPECTIVE –> CHANGE PERSPECTIVE NAME, CHECK (or) UNCHECK the required objects and items.
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.
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.
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:
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.
KPI –> New KPI –>
ASSOCIATED MEASURE GROUP: Text.Fact
VALUE EXPRESSION: [MEASURE] . [ACTUAL COST]
GOAL EXPRESSION: [MEASURE] . [ESTIMATED COST]
STATUS INDICATOR: TRAFFIC LIGHT
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
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