Forecasting using SAS Forecast Server, SAS/ETS, and more

Forecast Studio project | can we export the override values

Reply
Contributor
Posts: 27

Forecast Studio project | can we export the override values

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.

SAS Employee
Posts: 2

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

Posted in reply to TestingSAS
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!
Contributor
Posts: 27

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

sue let me know how and where

SAS Employee
Posts: 38

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

[ Edited ]
Posted in reply to TestingSAS

Hi:

 

I can think of two ways of doing it.

  1. 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. 
  2. 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:

  1. 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
  2. Either gather all the OUTVRD data sets from the hierarchy levels into one data set, or loop over the hirerarchy levels
  3. 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();                                                                                                                            
                                                     

 

Ask a Question
Discussion stats
  • 3 replies
  • 552 views
  • 1 like
  • 3 in conversation