Mindmajix

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:

Screenshot_99

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.

Screenshot_100

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 :

Screenshot_101

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


0 Responses on Learn to Define Perspectives and Translations in SSAS"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.