To prevent data values from being counted twice, totals and upper level members are not included in the downloaded results set.
In the Pivot section, shared members can be excluded from totals by disabling the Aggregate Shared Members option.
In addition, in the Pivot section all results are summed. Some Essbase aggregations may not sum member results due to outline calculations and member unary operators (+, –, *, /, ~). As a result, there may be difference shown between Essbase and Pivot totals depending on the outline structure and calculations of the cube.
Note: | Shared members are in bold below. |
Table 67. Shared Members (bolded) in the CubeQuery Section
| Qtr1 | |
|---|---|
100–10 | 5096 |
100–20 | 1359 |
100–30 | 593 |
| 100 | 7048 |
| ... | |
400–10 | 2838 |
400–20 | 2293 |
400–20 | –116 |
| 400 | 5005 |
100–20 | 1359 |
200–20 | 2963 |
300–30 | 2695 |
| Diet | 7017 |
Product | 24703 |
Note: | The Product total does not include the “Diet” member total of “7017” because it is configured in the Analytic Service outline to “no consolidate.” |
Note: | If the same results are inserted into a pivot, the Product total includes the value for the Diet member. Shared members are included in totals if the aggregation option is disabled in the Results section, but the “Product SKU, Shared” column is added to the data layout in the Pivot section. If the aggregation option is enabled in the Results section, share members are included in totals in the Pivot section whether the “Product SKU, Shared” is the data layout or not. |
Table 68. Aggregate Shared Members Enabled in the Results Set
| Qtr1 | |
|---|---|
| 100–10 | 5096 |
| 100–20 | 1359 |
| 100–30 | 593 |
Total | 7048 |
| ... | |
| 400–10 | 2838 |
| 400–20 | 2283 |
| 400–30 | –116 |
Total | 5005 |
| 100–20 | 1359 |
| 200–20 | 2963 |
| 300–30 | 2695 |
Total | 7017 |
Total | 31720 |
If the “Aggregate Shared Members” option is disabled, the total is included for the initial shared member, but not for any parent members above it: