Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Rollup credit/debit amounts
0 views
Skip to first unread message
TimXox
Dec 14, 2009, 9:53:01 AM12/14/09
to
Hi,
I am trying to build cude from fact table where grain is transaction and
each transaction has Amount with Credit/Debit indicator. If indicator =C I
have to use Amount* (-1) to roll it up and in other case just Amount.
Please advice how I may do it in most efficient way.
Thanks,
Tim.
I am trying to build cude from fact table where grain is transaction and
each transaction has Amount with Credit/Debit indicator. If indicator =C I
have to use Amount* (-1) to roll it up and in other case just Amount.
Please advice how I may do it in most efficient way.
Thanks,
Tim.
Carmaboy
Dec 15, 2009, 8:45:15 AM12/15/09
to
Tim,
You should consider doing the math in your ELT using the indictor
during the lookup (assuming your using SSIS). If that is not an
option for you, consider using an Account Hierachy in which you can
control the rollup using an Operator (+/-/~ add/substract/ignore).
0 new messages