If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: error  (Read 4040 times)

Offline Hanif12

  • Full Member
  • ***
  • Join Date: Jul 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
« on: 15 Nov 2017 02:36:13 am »
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