Hi all,

I have two dimensions Time Dimension(with Week hierarchy) and Config
Dimension(With Hierarchy - LEVEL1-->SERVERs)
Please go through the following table and let me know if this is the
default behavior of this aggregation type?


DAY1 DAY2 DAY3 DAY4 WEEK desc
SERVER1 50 10 10 Last non empty for server1

SERVER2 100 90 50 100 100 Last non empty for server2

SERVER3 25 100 50 75 75 Last non empty for server3

SERVER4 200 200 50 49 49 Last non empty for server4

MIN 375 400 150 224 224 Last non empty for LEVEL1

desc Sum for LEVEL1 on Day1 Sum for LEVEL1 on Day2 Sum for LEVEL1 on
Day3 Sum for LEVEL1 on Day4 Sum for LEVEL1 in a week

And hence if we look at Weeks values LEVEL1 value is not equal to Sum
(SERVER1, SERVER2, SERVER3, and SERVER4)

Regards,
Gayatri