I am having a problem loading from a Cognos PowerCube into the Metrics Store. The metrics are being loaded into the metrics store only at year level and for the first quarter of each year - not the other quarters or the months. There are no rejects in the kpi_value_stage_rejects table after loading. The business calendar is set with levels Year, Quarter and Month and the time dimension in the PowerCube has levels Year, Quarter, Month. Time Periods mapping in Metrics Designer is set to Use all Time Periods and the Metrics Studio Time Mappings are all mapped. Has anyone had this problem before???
