This content has been marked as final. Show 6 replies
How do I create a new calculated dimension from the sql load script?
I am loading date from sql query and would like to calculate week during load.
The below code works, but I cannot see WorkWeek as a dimension after load completes.
Let WorkWeek = Week(start_date);