Similar measure in fact table

View previous topic View next topic Go down

Similar measure in fact table

Post  podgeypoos on Mon Jun 03, 2013 8:12 am

I have a scenario at work where our finance department wants to see two different version of one measure, one is for internal use and one is for external use.
The scenario is our company must make a royalty payment for using a digital encoder for every product we sell.
Our supplier will see 1% of this and the finance department want it to be 2% for calculating their Profit and Loss.

I am trying to figure out if this data should live in the same fact table and one is called MP3RoyaltyInternal and the other is MP3RoyaltyExternal.
I have more examples like this whereby the fiance dept want their version of only some of the facts.

Is having multiple definition of the same fact advisable or will it get too confusing?

podgeypoos

Posts : 6
Join date : 2012-11-07

View user profile

Back to top Go down

Re: Similar measure in fact table

Post  BoxesAndLines on Mon Jun 03, 2013 9:02 am

It could be confusing, but I would still put it in the same fact table. I would look to views or the BI tool to ensure only the right metrics are exposed to the right groups.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Similar measure in fact table

Post  podgeypoos on Mon Jun 03, 2013 3:56 pm

Many thanks for the answer

podgeypoos

Posts : 6
Join date : 2012-11-07

View user profile

Back to top Go down

Re: Similar measure in fact table

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