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.




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 )




3) I defined a dataset.




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