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

Duplicate a dimension attribute in a fact table

3 posters

Go down

Duplicate a dimension attribute in a fact table Empty Duplicate a dimension attribute in a fact table

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

http://www.horus-df.com/

Back to top Go down

Duplicate a dimension attribute in a fact table Empty Re: Duplicate a dimension attribute in a fact table

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

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

http://aginity.com

Back to top Go down

Duplicate a dimension attribute in a fact table Empty Re: Duplicate a dimension attribute in a fact table

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

http://www.horus-df.com/

Back to top Go down

Duplicate a dimension attribute in a fact table Empty Re: Duplicate a dimension attribute in a fact table

Post  John Simon 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

http://jsimonbi.wordpress.com

Back to top Go down

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