SAP BPC 10 Total & Grand Total

[cosmas_phepar]

Hi guys,

I have difficulty in SAP BPC report:

Grand Total Qty is total of total Qty department and total Qty under department is total of all Qty cost center. Same with Mio column.

The department and cost center is dynamic, based on user choose (dimension override).

Is there any suggestion for the grand total and total column ?

Thanks.

[former_member186338]

Sorry, but you have to explain a bit more...

What dimensions are used

What hierarchy and members you have

Etc...

[cosmas_phepar]

Hi Vadim,

Thank you for your response.

Description is row axis, the dimension is asset.

Column UOM is local member only.

In the column, the dimension is department, cost center, UOM.

Department : IT, FAD, etc.

Cost center : cost center 1, cost center 2, cost center 3, etc.

UOM = Qty, Mio.

All column dimension can be base level or a parent.

No hierarchy needed for the dimensions.

The point is how do I get total cost center of Qty and Mio for each department.

And how do I get grand total of Qty and Mio for all department.

Thanks.

[former_member186338]

"Column UOM is local member only."-??? what do you mean... if you have UOM dimension in column axis...

In general it's not possible to implement your requirements.

Using Member Sorting and Grouping you can add only single local member before the group (sorted by Department ID). Using SUMIF you can sum for example only Q-ty. But you can't add a second local member to display Mio.

Vadim

[cosmas_phepar]

Hi Vadim,

If you confuse with column UOM (third column), you can ignore it.

Thanks.

[former_member186338]

Even without UOM it's not possible