Date dimension issue

[Sundaramoorthy]

Hi Team,

I'm facing an issue in transformer that after building the cube,measure values is getting added to only of the year dimension(2019)..For other years from 2014 to 2018, data was there in the cube source but it is not getting reflected in the cube. Here the data I'm getting in the cube is only for 2019 year & it's not an consolidated or summarized data for all years from 2014 to 2018.

Summary about this issue:

Previously it used .mdb as an source & now referring report as an data source. For date fields in the report, I have changed the data format from date timestamp to date for some of the date fields.whether it may be an issue?

Please advise on this.