An author creates a Report Studio report that contains Month, Product Line and Revenue.
Revenue has a footer to show the overall total. What will the author see in the generated Cognos
SQL for the Revenue footer column?

A.
XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as
Revenue

B.
XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as
Revenue2

C.
XSUM(XSUM(Sales_Fact.Revenue for
Time_Dimension.Month1,Product_Dimension.Product_Line) in
Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue

D.
XSUM(XSUM(Sales_Fact.Revenue for
Time_Dimension.Month1,Product_Dimension.Product_Line) at
Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1

Explanation: