Iredia Osadolor Posted January 19, 2021 Share Posted January 19, 2021 I am not sure why my query is not referreshing on spotfire dashboard,I would have to reload the data table before it updates. I am using version 10.3.3.42. Just to clearify my question. I have a few queries that I've loaded from SQL servers to spotfire dahsboard. They all refresh except for one query. I can however refresh it manually by right-clicking the query and hitting reload data table. How come this specific query is not included in the refresh and what can I do toresolve it moving forward Below is the sql query SELECT DATEADD(wk, -1, DATEADD(DAY, 6-DATEPART(WEEKDAY, [****].[****].Timestamp), DATEDIFF(dd, 0, [****].[O****].Timestamp))) as 'FirstDayOfWeek' ,[****].[****].planned ,LEFT([****].[****r].FunctionalLocation, 9) as ****PadFloc , [****].[****r].FunctionalLocation , [****].[****].WellName , datepart(wk, [****].[****].timestamp) as TimestampWeek , datepart(yyyy, [****].[****].timestamp) as TimestampYear , [****].[****].****Legacy , [****].[****].Timestamp , SUM(Variance) * -1 as 'Variance' , [Where] , Why , (SUM(Variance) * -1) / AVG(a.TotalProduction) as 'PctLoss' , [****].[****].FieldOperationsArea , StatusActions , PctTgt = Case [****].[****].****Legacy WHEN 'Bakken' Then .035 WHEN 'Legacy' Then .115 END FROM [****].[****] LEFT JOIN [****].[****] ON [****].[O****].PraNumber = [****].[****].PraNumber LEFT JOIN (SELECT SUM(Production) as TotalProduction ,[****].[O****].****Legacy ,Timestamp FROM [****].[****] LEFT JOIN [****].[****] ON [****].[****].PraNumber = [odr_nd].[****].PraNumber WHERE Production > 0 AND [****].[****].Timestamp >= dateadd(d,-360,getdate()) GROUP BY [****].[****].****Legacy ,Timestamp)a ON [****Timestamp = a.Timestamp and [****].[****].****Legacy = a.****Legacy WHERE [Where] IN ( 'Pumping Unit' ) AND WHY not in ( 'Bottleneck' ,'3rd Party' ,'Obstruction' ) AND [****].[O****].Timestamp >= dateadd(d,-360,getdate()) AND [****].[O****r].Status = 'PD - Producing' AND Variance < 0 AND UpDown = 'D' AND Why IS NOT NULL GROUP BY [****].[O****].BakkenLegacy , [****].[O****].timestamp , [Where] , Why , [****].[****r].WellName , LEFT([****].[O****].FunctionalLocation, 9) , [****].[O****r].FieldOperationsArea , StatusActions , Planned , [****].[O****].FunctionalLocation Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted January 20, 2021 Share Posted January 20, 2021 From the Data Canvas section can you check if the data table's data loading settings is set to Always New Data or Stored Data, https://docs.tibco.com/pub/sfire-analyst/11.1.0/doc/html/en-US/TIB_sfire... If it is set to Stored Data then changed to Always New Data or NewData when Possible Link to comment Share on other sites More sharing options...
Iredia Osadolor Posted January 21, 2021 Author Share Posted January 21, 2021 Thanks for your answer. But it was already set to Always New Data. However, i changed it to NewData when Possible just to give it a try to see if it will work. I will have to see if it refresh this friday cause i set it to refresh every fridayson the query. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now