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

error

Started by Hanif12, 15 Nov 2017 02:36:13 AM

Previous topic - Next topic

Hanif12

Hi guys,

I am facing one issue in cognos query studio. I have a data item "Amount" which is in number data type from backend. The source from backend(oracle) is a VIEW. After importing to FM, it is decimal datatype with (30,10) . When the amount exceeds 15 numbers in query studio report, it is automatically getting rounded. We are not using any round function at the model.  Please let me know, how to restrict this round off at 15th position.
Is there any limitation for the number in studio?

Ex: 1456258892256.1695 from DB
       1456258892256.17    from query studio(automatically rounding @15 position.

Sent from my vivo V3 using Tapatalk