We have an issue with Cognos Transformer category generation in a particular dimension.
The Category that can be seen in Transformer model, is not being displayed in the cube even when the data is available for that category.
Also, the values associated with categories are being displayed incorrectly.
We are using Report Studio reports as Source to build this cube.
Data validates perfectly between Source reports and Database.
But once data goes through Transformer to Cube, we are missing some categories and getting incorrect values for categories that are displayed.
We have tried deleting and regenerating the Categories. And then built the cube. That does not seem to work.
Please advise us on how to address this issue.
We are currently using Cognos 10.2.2.
Scratch this question. This was a data issue.