Click here to Skip to main content
Click here to Skip to main content
Technical Blog

Tagged as

Tabs in the SSAS cube designer

, 29 Aug 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
What We will learn? While creating cube using SQL server data tools or Business intelligence development studio we came across many tabs in the designer window. Let’s understand each one of the tab in short. 1. Cube structure a. Shows the current structure of the cube. Shows the available dimensions

What We will learn?

While creating cube using SQL server data tools or Business intelligence development studio we came across many tabs in the designer window. 1 Let’s understand each one of the tab in short.

1. Cube structure

a. Shows the current structure of the cube. Shows the available dimensions, Facts and relationships between them b. It let us include new dimensions which are not part of the cube right now. c. It let us include new measures which are not part of the cube right now.

2. Dimension Usage

After we include new dimension or measure into the cube it’s very important to connect dimensions and cubes. This tab let us decide how dimensions are connected to cube. 2

3. Calculation

This tab let us create new calculated members for the cube. Calculated members means members whose values will be calculated from other member’s. 3

4. KPI

KPI or Key value indicators let us display custom icons based on the current value. Note: Icon may or may not be supported in the client. Example when client is excel it shows perfectly fine but may be some other cube client will not support it. 4

5. Actions

Let us perform custom actions when particular cell (value in the cell) in the cube output is clicked. Note: Again it depends on the client. She/he may or may not have support for this. 5

6. Partitions

Usually inside cube for storing fact table data partitions are created. By default one partition will be created for one fact table. Those partitions can be seen in this tab. Sometimes we create multiple partitions for a single fact table. Example one partition will store historical data where as one will store current data 6 Advantages of creating multiple partitions are

  • Each partition can be pointing to different data source in short different physical location.
  • Each partition can be configured with different storage settings
  • Each partition can have different aggregations
  • Each partition can be processed independently and thus processing speed will be improved a lot.

7. Aggregation

Let us design the aggregation for the partitions. 7 Designing aggregation makes cube store aggregated values inside cube partition based on aggregation settings.

8. Perspectives

Perspective let us create different views for our cube. It’s not security. It’s just a view to make end users life easy. Every view will provide different information. Example: Perspective created for Product manager will show only dimensions and facts related to Product. 8

9. Translation

As the name implies it let us define meanings of various parts of the cube in various language 9

10. Browser

Using this tab developer will test the cube created using remaining 9 tabs. 10 Learn more on explaining Data Flow Tab and Data Flow Task in SSIS For technical trainings on various topics like WCF (Windows Communication Foundation), MVC (Model View Controller), Business Intelligence, Design Patterns, WPF, TFS and Basic fundamentals feel free to contact SukeshMarla@Gmail.com or visit www.sukesh-marla.com For more stuff like this, click here. Subscribe to article updates or follow at twitter @SukeshMarla

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Marla Sukesh
Technical Lead ShawMan Softwares
India India
Learning is fun but teaching is awesome.
 
Code re-usability is my passion ,Teaching and learning is my hobby, Becoming an successful entrepreneur is my goal.
 

For technical trainings on various topics like WCF, MVC, Business Intelligence, Design Patterns, WPF and UML and many more feel free to contact SukeshMarla@Gmail.com or visit justcompile.com or visit www.sukesh-marla.com

 

@Twitter
@Facebook
Follow on   Twitter   Google+   LinkedIn

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web01 | 2.8.141015.1 | Last Updated 29 Aug 2014
Article Copyright 2014 by Marla Sukesh
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid