单项选择题YouneedtoensuretheOrderControlteamisabletotrackthenumberofordersthatreachtheproductiondepartment.Whatshouldyoudo?()
A.Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.
B.Create a Server Time dimension. Within this dimension, enable the time periods year, month, and date. Select the Additional Manufacturing calendar option.
C.Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.
D.Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.