You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

VA not taking exact decimal places data from DB

Question
5
Views
0
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics

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:

  

MonthPrice
January, 20170.043301
February, 20170.044014
March, 20170.043852
April, 20170.042551
May, 20170.040786
June, 20170.044644
July, 20170.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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!