How to implement a pre-aggregation in Calculative View of HANA

[former_member308471]

Hi All,

Suppose I have a detailed data as below like

Product ID | Region | Sales Manager | Sales Value

A Mumbai Amit 200

A Mumbai Ajay 300

A Pune John 100

A Pune Amit 500

How to create a calculated column which will always give me Region wise Total dynamically as 500 for Mumbai ad 600 for Pune when I do preview at Semantics level.

Desired output as below

Product ID | Region | Sales Manager | Sales Value | Region Wise Total

A Mumbai Amit 200 500

A Mumbai Ajay 300 500

A Pune John 100 600

A Pune Amit 500 600

Note : I do have Aggregation node but some how it shows the same value as detailed granularity.

Regards,

Kiran

[Former Member]

Create another aggregation node and aggregate on product id, Region , then join it with the original projection node on product id and region.

[former_member308471]

Hi Subhasish,

I have more than 10-20 measures to be used to calculate relative % and the original view contains more than 100 dimensions.

Following the solution proposed by you it will create an extremely complex view.

Isn't there a cleaner way to implement this?

Regards,

Kiran