COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: perspolis09 on 07 Feb 2015 04:31:31 PM

Title: Getting a empty record while generating Category in Cube transfor
Post by: perspolis09 on 07 Feb 2015 04:31:31 PM
Hi gurus,

When I'm creating a regular dimension in Transformer model during that
time I'm adding a levels and after adding a level once we generate a category , and after
generating category , I'm clicking show diagram in show diagram , I'm able see all record  but this Rolling 12 months its empty?

I'm wondering why transformer generating a all but one hierarchy its empty?
So can anyone tell me why it is generation and what is the use of this
record .and if this record is generating by mistake then how I will avoid this data discrepancy?

Thanks in advance..

--
Thanks & Regards
Title: Re: Getting a empty record while generating Category in Cube transfor
Post by: MFGF on 08 Feb 2015 06:13:48 AM
Quote from: perspolis09 on 07 Feb 2015 04:31:31 PM
Hi gurus,

When I'm creating a regular dimension in Transformer model during that
time I'm adding a levels and after adding a level once we generate a category , and after
generating category , I'm clicking show diagram in show diagram , I'm able see all record  but this Rolling 12 months its empty?

I'm wondering why transformer generating a all but one hierarchy its empty?
So can anyone tell me why it is generation and what is the use of this
record .and if this record is generating by mistake then how I will avoid this data discrepancy?

Thanks in advance..

--
Thanks & Regards

Rolling 12 Months sounds like it's a relative time category defined in a time dimension? Is the dimension a time dimension based on a date? What relative time rules does this category use? Is it manually created? Do the rules within it return members for the dates in your data source - eg if you have dates for the past two years in your data source and the offset in the relative time category is -4 for the year level (from the current date) it's not going to contain any members...

MF.