Skip to Content
0
Nov 25, 2014 at 10:41 PM

How to reuse calculated columns in IDT

189 Views

Hi,

I am new to IDT and have a basic question. I have created a calculated column in the data foundation layer using existing measures in the fact table. Can I use this newly created calculated column in the definition of another calculated column.

Example:

CC1 definition = Measure 1 - Measure 2 + Measure 3

CC2 definition = CC1 + Measure 4

I did not find a way to define CC2 without writing the whole formula for CC1 all over again (i.e. Measure 1 - Measure 2 + Measure 3 + Measure 4).

Any advice would be really helpful.

Thanks.