COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: 3000gt on 26 Sep 2007 03:23:27 PM

Title: Time Based Partition in Cognos 7.4 Powerplay
Post by: 3000gt on 26 Sep 2007 03:23:27 PM
Hi

I am new for powerplay and we are doing sample cube with time based partitioned on time dimension

my time dimension as years, quarters, months, day

When select the option of timebased partition, powercube is created and years are created as child cubes. but years are reapeating, as we have source data for three years only,(2005,2006,2007)
but in this scenario, years are repeating, i am putting in a doc to get a clear picture for everyone

whole idea for doing, later i can update only selected year, Is it something i can do.. ? or no


Thanks
3000gt :)
Title: Re: Time Based Partition in Cognos 7.4 Powerplay
Post by: a027309 on 09 Nov 2007 04:28:32 PM
Trying setting the time based partitioning and leaving the "Summarize all external categories..." blank. I think that may be causing your issue.

BTW - is your username a reference to your car? I have a '93 3000GT VR4...
Title: Re: Time Based Partition in Cognos 7.4 Powerplay
Post by: 3000gt on 13 Nov 2007 06:26:40 PM
me having 98 3000gt sl,, iam in detroit, how about u,,,