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

Similar measure in fact table

2 posters

Go down

Similar measure in fact table Empty Similar measure in fact table

Post  podgeypoos 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

Back to top Go down

Similar measure in fact table Empty Re: Similar measure in fact table

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

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

Back to top Go down

Similar measure in fact table Empty Re: Similar measure in fact table

Post  podgeypoos Mon Jun 03, 2013 3:56 pm

Many thanks for the answer

podgeypoos

Posts : 6
Join date : 2012-11-07

Back to top Go down

Similar measure in fact table Empty Re: Similar measure in fact table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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