Add Time_Stamp field in the Fact_table and then bring it in this aggregated table as a field
num(today()) as Time_Stamp,
Load sum(Rev) as Rev,
group by SoS_Year,
Thank you Sunny and Kushal, both are valid ways, the resident and the preceding load. My topic is that,my original table (including the time_stamp) with the group (without the time_stamp) is working fine as well, although I ignored the rule to put the time_stamp in the group by statement .
So is this a valid way, or should I better stick to the resident or preceding load which you have presented? A small explanation would be great, thx a lot.