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

 

News:

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

Main Menu

Getting a empty record while generating Category in Cube transfor

Started by perspolis09, 07 Feb 2015 04:31:31 PM

Previous topic - Next topic

perspolis09

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

MFGF

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.
Meep!