VA not taking exact decimal places data from DB

Pathak Sonkar

Summary

VA not taking exact decimal places data from DB

Content

DEAR Gurus,

I have two problems:

1. Here the data coming from DB is not getting populated exactly as it is in VA Line Graph.

Details:

Environment: Oracle VA 12.2.1.3

Sample Records:

  

Month	Price
January, 2017	0.043301
February, 2017	0.044014
March, 2017	0.043852
April, 2017	0.042551
May, 2017	0.040786
June, 2017	0.044644
July, 2017	0.047325

This data is in DB. When I am importing this to VA, the Price is getting rounded to 2 decimal places and hence am getting a straight line in VA graph.

I tried to use calculations and rounded this column to 6 decimal digits, but no use.

2. In the same example, I want to populate the values for MONTH in ascending order, but in VA, this value is sorted alphabetically.

How can I sort this in Date Format? Can we hide a column and then sort on this column (like we do in OBIEE)?

Request you GURUS to help me get in the right direction.

Note: I have tried different sources, but everytime, the data is getting rounded to 2 digits only.

Thanks in advance.