Portia wants to create a calculated measure in Excel.To do this,she creates a PivotChart report using the data stored in an Analysis Services cube.Next,she clicks on a tab "A" and then in group "B," she chooses OLAP Tools MDX Calculated Measure to open the New Calculated Measure dialog box.What can A and B be in the procedure?
A) A-Design tab,B-Data group
B) A-Developer tab,B-Code group
C) A-Analyze tab,B-Calculations group
D) A-Design tab,B-Table Style Options group

Question

Portia wants to create a calculated measure in Excel.To do this,she creates a PivotChart report using the data stored in an Analysis Services cube.Next,she clicks on a tab "A" and then in group "B," she chooses OLAP Tools > MDX Calculated Measure to open the New Calculated Measure dialog box.What can A and B be in the procedure?
A) A-Design tab,B-Data group
B) A-Developer tab,B-Code group
C) A-Analyze tab,B-Calculations group
D) A-Design tab,B-Table Style Options group

Quizplus · Accepted Answer

The Analyze tab is where the options for working with PivotTables and PivotCharts are located. The Calculations group on this tab includes the MDX Calculated Measure option, which is used to create a new calculated measure in the PivotChart report.

Portia Wants to Create a Calculated Measure in Excel