COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: Sarayucog on 04 May 2011 07:24:57 AM

Title: Transformer error
Post by: Sarayucog on 04 May 2011 07:24:57 AM
Hi All,

I am creating a transformer model from Package as datasource. In that I have a Time dimension and it should contains Year, Quarter, Month and Day.

Year and Month's data type is declared in package as integer.

Here my promblem is

I have all other dimensions in dimension map and to create Time dimension first I have taken Year. To check the categories I have generated Categories. When I am checking in the Show Diagram in the Year Level its displaying the only one category like a number 24265897, but it should show yeats like 2000, 20001, 2002 etc.

What is the problem. Please tell me the solution to get the individual years.

Thanks in advance.