Percentage of customers from a district
3 posters
Page 1 of 1
Percentage of customers from a district
I need to determine how best to model the percentage of schools in a school district that are customers of our product. I have a measure for distinct count of schools that I can view by district, but I'm not sure how best to compare this to the total number of schools in a district. I need to calculate, among other things [total schools in district] - [ customer schools in district] and [customer schools in district] / [total schools in district]. What is the best way to model the total number of schools in the district? Would this be a measure in a fact table or an attribute of a dimension? Also, I'm using the Microsoft BI stack and SSAS.
JSchroeder- Posts : 12
Join date : 2012-03-29
Re: Percentage of customers from a district
if granularity of fact is district and you want to calculate all these calculations at report layer then store this in the fact itself, else as an attribute in dimension.
Vishy- Posts : 75
Join date : 2012-02-28
Location : India
Similar topics
» Store Business Hours in Time Of Day dimension?
» Help with ragged multiple hierarchy design
» Handling customers merged via MDM
» DimCustomers and DimGeography - How to Measure Customers?
» Many-to-many attributes for Customers and DW design
» Help with ragged multiple hierarchy design
» Handling customers merged via MDM
» DimCustomers and DimGeography - How to Measure Customers?
» Many-to-many attributes for Customers and DW design
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum