Market Share in Fact Table

View previous topic View next topic Go down

Market Share in Fact Table

Post  exhortae on Thu Aug 25, 2011 6:03 am

Hi,

I wonder if I can put market share values in a fact table. Let me explain myself :

For a university project I have to provide for an automobile company the following values.

- Sells by volumes.
- Market shares.


Sells by volumes is an easy go, but I'm having difficulties with market shares. Do I need to put market shares values in the fact table, or is it better to just calculate them in reports.

Thanks

exhortae

Posts : 30
Join date : 2010-08-01

View user profile

Back to top Go down

Re: Market Share in Fact Table

Post  VHF on Thu Aug 25, 2011 8:50 am

Percentages don't aggregate well, so it is better to calculate them in the report when possible.

You could store market share in a periodic snapshot fact table, but then you are pretty much locked into the grain of the fact table for reporting purposes because percentages won't correctly add or average when aggregating to a higher summary level. If you calculate the percentage in the report you can provide accurate results at any level of drill-down.

VHF

Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

View user profile

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