–> 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.
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.
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.
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.
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.
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.
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.
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|
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.