COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Metrics Studio => Topic started by: Christine.Beswick on 16 Sep 2009 09:46:57 AM

Title: Metrics Studio 8.4 Time level load problem
Post by: Christine.Beswick on 16 Sep 2009 09:46:57 AM
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???