Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to integrate a forecast into a report?

Posts: 55

How to integrate a forecast into a report?

[ Edited ]

Hi there,


We want to use a linegraph in an exploration to create an updated forecast every month. This forecast should be displayed in a comprehensive report (dashboard). The only way updating this graph in the report (I'm aware off) is to export the graph as a report in the exploration and then importing this report in the main report. This however is not a preferable solution because we have to repeat this excercise every month. The linegraph needs quite some design modifcations to fit in the report.


Is there some other way to achieve what we want?


Thanks, Frank



Occasional Contributor
Posts: 15

Re: How to integrate a forecast into a report?

Posted in reply to Frank_Boekamp

Hi There,



In SAS VA, the Data Exploration, FORECAST feature is available\possible using Line Chart.  We can export this VISUALIZATION into REPORT (File - Export - Exploration as Report), but it is static.  We can't do any modifications if we add it in one of the section in Report Designer.  Even we can't publish VISUALIZATIONs to End Users or Business Users in Report Viewer.  So each and everytime we need to follow the above steps until the options are available in Report Designer.


These features (Forecast feature using Line Chart, Sankey Diagram, Decision Tree, Heat Map, Box Plot) are NOT available in Report Designer.  If SAS will update these features in coming versions in SAS VA 7.4 or 7.5, we can overcome these kind of issues.


Thanks & Regards,

Venu Murala  | Sr. SAS Consultant, USA.



Venu Murala
Posts: 55

Re: How to integrate a forecast into a report?

Posted in reply to muralavenu_gmail_com

I also really would like to see a better integration of forecasts etc in the designer. There is however an easier way of exporting the results of a forecast to designer: you can export the data from a forecast as an Excel file and import this file into designer. This way you have maximum flexiblity in desiging the linegraph. Pitty that we can not automate this step...Smiley Frustrated



Ask a Question
Discussion stats
  • 2 replies
  • 1 like
  • 2 in conversation