Duplicate a dimension attribute in a fact table

View previous topic View next topic Go down

Duplicate a dimension attribute in a fact table

Post  remiby on Tue Apr 17, 2012 1:01 pm

I have a dim_transaction table containing all the different kind of transactions I can execute on a bank account. This table contains for every transaction an attribute telling whether the transaction is a debit or a credit. In my transactions fact table I want to be able to distinguish between credit an debit transactions. Is it a good idea for your point of view to add a dimension debit_credit in the fact table copied from the dimension table ? Or should I access it via my dimension table in my cube definition?

remiby

Posts : 19
Join date : 2012-04-10
Location : Paris, France

View user profile http://www.horus-df.com/

Back to top Go down

Re: Duplicate a dimension attribute in a fact table

Post  ngalemmo on Tue Apr 17, 2012 1:27 pm

The measures should be negative or positive depending on its effect on the balance. That should be sufficient to determine which are credits or debits.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Duplicate a dimension attribute in a fact table

Post  remiby on Wed Apr 18, 2012 6:09 am

I need to be able to analyse credits vs debits so I need an axis of analysis to do that.
Anyway, in a general case does that make sense to duplicate a dimension attribute in a fact table as a degenerated dimension?

remiby

Posts : 19
Join date : 2012-04-10
Location : Paris, France

View user profile http://www.horus-df.com/

Back to top Go down

Re: Duplicate a dimension attribute in a fact table

Post  John Simon on Wed Apr 18, 2012 6:28 am

Why would you need to be able to distinguish this from the fact table without using the dimension table?

Do not create a degenerate dimension as you cannot then use this attribute properly in a BI tool.

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.com

Back to top Go down

Re: Duplicate a dimension attribute in a 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