Duplicate a dimension attribute in a fact table
3 posters
Page 1 of 1
Duplicate a dimension attribute in a fact table
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?
Re: Duplicate a dimension attribute in a fact table
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.
Re: Duplicate a dimension attribute in a fact table
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?
Anyway, in a general case does that make sense to duplicate a dimension attribute in a fact table as a degenerated dimension?
Re: Duplicate a dimension attribute in a fact table
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.
Do not create a degenerate dimension as you cannot then use this attribute properly in a BI tool.
Similar topics
» Dimension Attribute vs Fact Table Key
» How to avoid duplicate Records in the fact table?
» data as an attribute on a dimension or a key on the fact table
» attribute on fact table or dimension table?
» Single Attribute Dimensions - why not instead write textual attribute into Fact table?
» How to avoid duplicate Records in the fact table?
» data as an attribute on a dimension or a key on the fact table
» attribute on fact table or dimension table?
» Single Attribute Dimensions - why not instead write textual attribute into Fact table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum