Skip to Content
1

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

Feb 04, 2017 at 06:02 AM

120

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Subhasish Haldar Feb 04, 2017 at 07:09 AM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0