You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?()
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.
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.