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.
- 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.
正确答案:D
答案解析:有
微信扫一扫手机做题