topic Re: Forecast Studio project | can we export the override values in SAS Forecasting and Econometrics

Forecast Studio project | can we export the override values

TestingSAS — Tue, 27 Oct 2015 22:11:26 GMT

Hi All,

in myproject, if i override few values, can i export and import in another project?

i don't want to copy and paste the data but want to export into a file and then want to import it into the project.

Re: Forecast Studio project | can we export the override values

wandas — Thu, 29 Oct 2015 14:44:31 GMT

We are currently working on new forecast override functionality for the next release. Importing external overrides is a requirement under consideration. As Product Manager of SAS Forecasting (Forecast Server, Forecast Studio, FSC, etc), I'd like to talk with you about this topic. Please contact me directly to discuss. Thanks!

Re: Forecast Studio project | can we export the override values

TestingSAS — Thu, 29 Oct 2015 15:09:08 GMT

sue let me know how and where

Re: Forecast Studio project | can we export the override values

mitrov — Mon, 02 Nov 2015 16:05:21 GMT

Hi:

I can think of two ways of doing it.

Simply make a copy of the project. The copy operation will preserve the overrides. Then change the project settings you want. This is the easiest way.
The second method requires some simple coding that uses the batch macro %FSSETOVR to add the overrides to the new project.

The flow for method 2 is as follows:

set your libraries corresponding to the hierarchy of your source project. You can copy the code from "libraries_declaration.sas" in your project folder roor directory
Either gather all the OUTVRD data sets from the hierarchy levels into one data set, or loop over the hirerarchy levels
Use the %FSSETOVR macro to apply the overrides to the new project.

This is just an example of the code where the original project has OUTOVRD data set at three levels.

**********************************************************************                                                                  
* DECLARING LIBRARIES.                                                                                                                  
*********************************************************************;                                                                  
                                                                                                                                        
%let HPF_LIBNAME_OPTIONS=;                                                                                                              
                                                                                                                                        
%let HPF_PROJECTDIR = C:\SAS\SASForecastServer14.1\Default\Projects\myOldProject\;                                                      
libname _project "&HPF_PROJECTDIR" &HPF_LIBNAME_OPTIONS;                                                                                
libname _top "&HPF_PROJECTDIR\hierarchy\top" &HPF_LIBNAME_OPTIONS;                                                                      
libname _HPF0 "&HPF_PROJECTDIR\hierarchy\regionName" &HPF_LIBNAME_OPTIONS;                                                              
libname _HPF1 "&HPF_PROJECTDIR\hierarchy\productLine" &HPF_LIBNAME_OPTIONS;                                                             
libname _HPF2 "&HPF_PROJECTDIR\hierarchy\productName" &HPF_LIBNAME_OPTIONS;                                                             
libname mylib "c:\FS";                                                                                                                  
                                                                                                                                        
                                                                                                                                        
                                                                                                                                        
**********************************************************************                                                                  
* GATHER OVERRIDES                                                                                                                      
*********************************************************************;                                                                  
                                                                                                                                        
data mylib.allovrd;                                                                                                                     
   set _hpf2.outovrd _hpf0.outovrd _top.outovrd ;                                                                                       
run;                                                                                                                                    
                                                                                                                                        
                                                                                                                                        
**********************************************************************                                                                  
* APPLY OVERRIDES TO NEW PROJECT                                                                                                        
*********************************************************************;                                                                  
                                                                                                                                        
                                                                                                                                        
%fslogin (user     = yourSASUserName,                                                                                                           
          password = yourSASPassword,                                                                                                         
         );                                                                                                                             
                                                                                                                                        
%fssetovr(ovrds=mylib.allovrd,                                                                                                              
          projectName=myNewProject,                                                                                                     
          environment=default,                                                                                                          
          reconcile=YES,                                                                                                                
          outfailed=IHopeNone                                                                                                           
         );                                                                                                                             
                                                                                                                                        
                                                                                                                                        
%fslogout();

Re: Forecast Studio project | can we export the override values

SINNETIC — Fri, 10 Apr 2020 16:27:47 GMT

Hello.

Do you know if actually, the current version of SAS Forecast desktop has the functionality incorporated?