Measures at different hierarchy
3 posters
Page 1 of 1
Measures at different hierarchy
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.
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
Re: Measures at different hierarchy
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.
Since many of the measures are at different grains, there would be multiple fact table depending on the dimensionality of the measure.
Measures at different hierarchy
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
![-](https://2img.net/i/empty.gif)
» Measures based on different hierarchy levels
» Measures in FTs or Descriptions in DTs
» Changing measures!
» Measures in Dimension?
» Help designing star schema
» Measures in FTs or Descriptions in DTs
» Changing measures!
» Measures in Dimension?
» Help designing star schema
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|