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

Market Share in Fact Table

2 posters

Go down

Market Share in Fact Table Empty Market Share in Fact Table

Post  exhortae Thu Aug 25, 2011 6:03 am


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.



Posts : 30
Join date : 2010-08-01

Back to top Go down

Market Share in Fact Table Empty Re: Market Share in Fact Table

Post  VHF 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.


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

Back to top Go down

Back to top

- Similar topics

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