Measures at different hierarchy

View previous topic View next topic Go down

Measures at different hierarchy

Post  winny on 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

View user profile

Back to top Go down

Re: Measures at different hierarchy

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Measures at different hierarchy

Post  zoom on 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

View user profile

Back to top Go down

Re: Measures at different hierarchy

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