Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Measure Creation from Dimension

2 posters

Go down

Measure Creation from Dimension Empty Measure Creation from Dimension

Post  naras 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

Back to top Go down

Measure Creation from Dimension Empty Re: Measure Creation from Dimension

Post  Jeff Smith 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

Back to top Go down

Back to top

- Similar topics

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