Measure Creation from Dimension

View previous topic View next topic Go down

Measure Creation from Dimension

Post  naras on Wed Oct 05, 2011 4:50 pm

Hi All,

I am new to SSAS, I want to create a measure based on the particular dimension. Is there a way to do that?

For example Employee Dimension, I want to count the number of employees in total?

Also if we want the total employees on date wise etc...?


Thanks

naras

Posts : 1
Join date : 2011-10-05

View user profile

Back to top Go down

Re: Measure Creation from Dimension

Post  Jeff Smith on Wed Dec 14, 2011 5:09 pm

A measure is a Fact and belongs in the Fact Table.

Fact tables are intended to be used to store factual information. Dimensions are intended to store descriptive data. You can force the dimension table to store the measure and it might work, but you run the risk of causing major problems down the road.


Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

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