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

Measures at different hierarchy

3 posters

Go down

Measures at different hierarchy Empty Measures at different hierarchy

Post  winny Mon Aug 31, 2015 11:26 pm

could someone please provide me some suggestion on this?

Users are using an application for scoring a party location by observing the environment in the store.

Application calculates scores at different hierarchies.



I dont want to recreate a formula so I stored the scores in the dimension tables itself.

I am going in right path?

please suggest Thanks a million.


Last edited by winny on Thu Feb 04, 2016 11:01 pm; edited 2 times in total

winny

Posts : 4
Join date : 2011-03-23

Back to top Go down

Measures at different hierarchy Empty Re: Measures at different hierarchy

Post  ngalemmo Wed Sep 02, 2015 5:24 pm

No, if you are trying to implement a dimensional model. The scores are measures which belong in a fact table. Your dimensions are observation, subscale, item and observation.

Since many of the measures are at different grains, there would be multiple fact table depending on the dimensionality of the measure.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Measures at different hierarchy Empty Measures at different hierarchy

Post  zoom Fri Sep 04, 2015 8:57 am

Your "Party Location dimension" should have the address of the location. Party location score exist on the fact table. You also need a date dim to show what date that event happened and what is the score for that event on a specific day.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

Back to top Go down

Measures at different hierarchy Empty Re: Measures at different hierarchy

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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