Aggregation not working in CV-SPS08

[Former Member]

Hi Experts,

I have a calculation in which my aggregation node is not working as expected. I have to aggregate based on region from both the tables(Aggregation_1 and Aggregation_2 ) and then join it and pass on to the final report.

Both Aggregation_1 and Aggregation_2 is displaying multiple rows for a region. Not sure why the aggregation is not happening.

Could you please guide on this.

Thanks

Mani

[Former Member]

Hello,

I found out that aggregation was not happening in the aggregation node because I did not add the columns to aggregate by right clicking and use  'Add to Aggregate' option.

Once I have done it ,it is working. I was in an assumption that it will automatically aggregate the numeric columns.

Thanks

Mani

[rindia]

Hi Mani,

You can do the data preview for each node separately and can find out at which node the result is improper.

[anindya_bose]

Hello Mani

For aggregation to work you need to take right column/Columns.  For example, you have date as per Region and Country .

Region      Country            Sales

ASIA        India                  100

ASIA        China                200

ASIA        Sri Lanka            150

AMER      USA                  500

EUROPE  UK                    170

AMER      Canada              300

Now, if you add region and sales ( as aggregated column ) , you should get

ASIA        450

AMER      800

EUROPE  300

To comment on your model, I need to see what is your base data and how you have defined the aggregation.

Also check Aggregation VS Projection ! thread for great explanation .

Cheers

Anindya