I have written a list report against a TM1 dimensional cube package. The bulk of the report contains elements from the measure dimension of the cube. The measure dimension elements contain both numeric and character data fields. One of these fields is populated by users entering a ranking of items for their upcoming budget requests. In Report Studio, this field sorts as if it is a character field. Is there a way to cast this field as an int WITHOUT also casting all the other measure data fields. What I have encountered is that if I create a new data item that casts the ranking field as int, it causes all the other data fields from the measure to display as zeroes.
Any help would be appreciated!
Thanks!
I wanted to follow up that this issue is a known issue with Cognos BI 10.1.1, and it is in IBM PM54643. The issue is character measures from TM1 data cubes experience a format change if an item within the measure contains a local function. This issue is fixed in Cognos BI 10.2.
Thank you!