Eng-Kiat.E.K.Tan

Creating Trends using RTtrends ( Source is Oracle)

Discussion created by Eng-Kiat.E.K.Tan on Nov 12, 2009
Latest reply on Nov 23, 2009 by cescamilla

Hi, i need some advices on how to create a RTtrend using a source from relational database. I only have the option of using RTtrend webpart. Other options such as processbook has also failed. 

 

1) I defined 2 tags as
Mytime5 is ‘*-180d’
Current is ‘*’
Attribute1 is the value I want to display.

 

 1a.jpg

 

2) My SQL Table structure is similar to the document: ID, STARTDATE and Value.
Hole_Name, Startdate, GASProd ( Due to Data restrictions laws, I cannot post it openly )

 

1b.jpg

 

3) I defined a dataset.

 

1c.jpg

 

4) However, the trend is not showing any values beyond 8 days ? The value i have in Oracle is over one whole year.

 

1d.jpg

Outcomes