If you are unable to create a new account, please email support@bspsoftware.com



MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Date dimension issue

Started by Sundaramoorthy, 08 Jun 2019 01:07:13 AM

Previous topic - Next topic


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.