COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: kalyan_sekhar1 on 18 May 2008 02:58:10 AM

Title: converting Query subject to Measure Dimension
Post by: kalyan_sekhar1 on 18 May 2008 02:58:10 AM
Hi,

There is a Qery Subject (monthly fact) which has actual and target values. When i view the data in the query subject it shows correctly (6,6.34...).

But when i convert into measure dimension the data is loosing its type completly..... the data is showing as 4.23335445456454565E+10

Can some one tell me the reasons for it ?

Thanks
Title: Re: converting Query subject to Measure Dimension
Post by: kalyan_sekhar1 on 18 May 2008 03:16:49 AM
Hi All:

I updated the each query item usage as 'Unknown' and converted the Query Subject into the Measure Dimension. I can see the right results. Can some one provide me what possible reason for it to convert the value as into exponential as mentioned above.

Thanks