How to add non additive calculated measures in ssis

Question

I have 3 non additive measure that were calculated in derived column transformation.Now, I did the aggregate transofrmation to sum up my additive measure as the the last 3 I didnt put them in the aggregate but when I was trying to insert my measure to fact table those last 3 didn't show up ! How to insert them in the fact table should I use another transofrmation and what is it ? enter image description here

score 0 · Answer 1 · edited May 23 '17 at 12:19

0

The problem is that the Aggregate Transformation does not allow you access to non-aggregated data.

Your best be would be to move the derived column transformation after the aggregate transformation. Otherwise, I covered how to access that data in my response on this question Using SSIS, How do I find the cities with the largest population?

edited May 23 '17 at 12:19

Community

1
1

answered Jul 22 '12 at 22:12

billinkc

59,250
9
102
159

How to add non additive calculated measures in ssis

1 Answers1