Calendar day TIME dimension in BPC10

Hi There,

I am trying to setup a custom time dimension in BPC10 ( BW740 SP15 and BPC810 SP10).

Time dimension has calendar days, weeks, months and years.

Looks like I am not able to correctly configure the properties so that Parents gets correctly aggregated.

At the moment, only the $value on last day of the month is shown as the total for entire month.

Can you please guide how to set this up correctly?

Here is how some of the masterdata rows looks like:

Thanks,

PS