Solved: Aggregation node not aggregating the value in Calc...

Hi All,

I am creating a calculation view of type CUBE to combine the results of 2 Analytical View and a Scripted Calc View.

Demand Analytical View(Projection_2):

This gives a demand value based on material and material description

FAD Analytical View(Projectioin_1):

This gives FAD values as per Material and Description

I am using UNION on two analytical view, We can see two separate rows one row each from analytical views FAD and Demand.

I have used Aggregate Node to aggregate that result, But aggregation is not happening. for eg: Material X1234 still has two rows.

So when joining this with Mat Percentage Calc view to take an other attribute and value

Mat percentage Calc View:

Join with Aggregation Node gives two records and repeats PERC value 21 for two records:

Default Aggregation in the Calc View Aggregates 21 and doubles the value to 41 for material X1234 in PERC Column

I am expected the value 21 in PERC. But this is not happening because of Aggregation node is not aggregating the union node results.

Can some one please let me know what is the reason for this weird behavior of Aggregation Node.

Thanks,

Rithika

rindia · ‎2016 Jul 18

Hi Rithika,

Under union node, go to Manage mappings (by right click) and you will observe that is Null is ticked.

That's why you are getting null values. To avoid this, use value zero in Constant Value column as shown below.

Set the value accordingly for all measures.

Regards

Raj Kumar Salla