KB274087: How to apply different aggregations to subtotals and grand total in a SAP BW based report in MicroStrategy?

OVERVIEW 
In some business scenarios, users may wish to apply the maximum to subtotals but let the grand total sum up all the subtotals as shown below. This technical note will describe the steps required to achieve this requirement in a report referring to a SAP BW source.

 
PREMISE
This is best explained through an example. This technical note will describe the steps based on the following MDX report, which consists of two attributes and one metric.

 
STEPS:

1. Create project attributes to which the MDX cube attributes will be mapped. The object mapping is necessary because a custom subtotal will have to be created later and the custom subtotal can only refer to project objects.

1. Map the MDX cube attributes to the created project attributes.

1. Create a custom subtotal object with the following definition.

Sum(Max(x) {@, [Year_PRJAttrbt]} ) {@}

1. Edit the Sales metric and add the custom subtotal to the “Available subtotals for metric” section.

1. Create a report with the project attributes and Sales metric. Apply the custom subtotal as shown below.

1. The resulting report will look as follows.