Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previous year. They also want to see the total for periods, up to and including the quarter selected.
Which of the following dimensional functions could the report author use to create this report?
A. Ancestor, currentMember, lead, total
B. OpeningPeriod, order, quarter, Firstsibling
C. Cousin, tuple, closingPeriod, aggregate
D. ParallelPeriod, tuple, periodsToDate, aggregate