Visually BI: SSAS part 2

https://mamatucci.wordpress.com/2012/03/19/visually-bi-ssas-part-1/

In this 2nd part the topic covered are : add attributes for a dimension, define user hierarchies, setting AttributeHierarchyVisible property, setting  attribute relationship, defining KeyColumns property and NameColumn property,User Hierarchy and Attribute relationships.

 

The map is here

#SSAS.O.2

 

http://dl.dropbox.com/u/63365339/BI.Blog/Visually%20BI%20SSAS/%23SSAS.O.2.jpeg

 

The map topics are:

.dim file

the definition are here so you have to modify each dim file generated by the cube wizard

clip_image001

identify the slice and dice attributes

rename with friendly names

Cube Project

add attributes for each dim

drag the attributes from data source view to the attributes pane

clip_image002

rename them

with friendly names

clip_image003

define user hierarchies

drag attributes from the attributes pane to the hierarchies pane

the top to bottom (the most granular)

clip_image004

set AttributeHierarchyVisible property

to hide pk (usually)

clip_image005

browse them

Process the dim and then check the hierarchy in the browser

clip_image006

set attribute relationship

to create an attribute relationship drag the Date attribute in the Attribute Relationships tab onto the next-most-granular attribute (Month) and so on

from this

to

clip_image007

to

clip_image008

define key with multiple attributes

Ex the quarter calendar key is duplicated, so we need to build in on a combination of key to make it unique (for months too)

KeyColumns property

ex for the Quarter

clip_image009

the 2 keys together will give the necessary unique value

NameColumn property

The multi key need a column to show the name to the user

clip_image010

classify a dimension type

Dimensions and attributes can be classified to introduce new usability features

To classify a dimension, click the Date dimension and select Time from the Type drop-down box (in the Properties window).

clip_image011

User Hierarchy

attributes hierarchy to make easier to navigate

without

Ex:

you should drag

· year

· quarter

§ month

· day

to see measure at day level

with

ex:

having a date hierarchy

you drag only it, and then you can navigate it (the struct is already arranged)

Attribute relationships

Attribute relationships allow you to create relationships between dimension attributes, much like foreign key relationships in SQL Server.

performance tuning

the cube id build faster as attributes have a structured relationship

data security

The user can browse more meaningful data

Ex

CustomerID (primary key) -> City -> State -> Country

means

From a State X I’ll see only the City of that state, not city of others state

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s