Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 04, 2017 at 07:09 AM

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

    Add comment
    10|10000 characters needed 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