Dimension vs Attribute

View previous topic View next topic Go down

Dimension vs Attribute

Post  Mohit on Thu Jun 28, 2012 11:20 am

Hi


Can you please let me know when should we go for a separate dimension?

For example, for our Sales reporting purpose, if we need to show only Customer Name along with other sales attribute so is it required to create a separate Customer dimension for this attribute or It can be kept in sales dimension as an attribute?


Thanks in Advance!!

Mohit

Posts : 2
Join date : 2012-06-28

View user profile

Back to top Go down

Re: Dimension vs Attribute

Post  Jeff Smith on Thu Jun 28, 2012 5:38 pm

Chances are, you'll create aggregates for Sales that don't include individual customers, which suggests that seperate dimensions would be in order.

Lets say you have 1 million customers and 4 sales regions. And lets say over the course of a year, the 1 million customers did a total of 100 million transactions (your fact table). Lets say you want to roll up those transactions by the 4 sales regions. If Sales Region is in your Customer Dimension, your query would include a join between 1 table with 100 million rows and a table with 1 million rows, and then aggregate the data to the 4 sales regions.

But if the 4 sales regions were in their own dimension, then your query would be 1 table with 100 million rows to a table with 4 rows, which would be a considerable performance improvement.


Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Dimension vs Attribute

Post  BoxesAndLines on Fri Jun 29, 2012 9:25 am

Sales dimension sounds fishy to me. It sounds like a 1-1 to a sales fact. Sales are things you count, not filter by.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Dimension vs Attribute

Post  Mohit on Fri Jun 29, 2012 12:13 pm

Thanks Jeff !!!!
This answers to my question.

Mohit

Posts : 2
Join date : 2012-06-28

View user profile

Back to top Go down

Re: Dimension vs Attribute

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum