https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1665#M95 We are using Forecast Studio to set up and run large amounts of forecasts. Each project has it's own directory with a folder called hierarchy. In Hierarchy, there could be multiple folders depending upon how you set up the project hierarchies. In each hierarchy level there are multiple SAS data set created. <BR /> <BR /> We would like to allow users access to the data at the project folder level and allow them to drill down to folder containing project/hierarchy level data. In EG, we can look at the server view and see libraries and files. We can expand files and find the project directory/hierachy level desired. However, in AMO when we open a data source from server the only thing we seem to have access to is defined libraries. Why? What are we missing ? How do we make this work for the AMO users?<BR /> <BR /> (Defining a separate library for each project/hierarchy level would be a nightmare) Fri, 27 Oct 2006 19:42:51 GMT LAP 2006-10-27T19:42:51Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1665#M95 We are using Forecast Studio to set up and run large amounts of forecasts. Each project has it's own directory with a folder called hierarchy. In Hierarchy, there could be multiple folders depending upon how you set up the project hierarchies. In each hierarchy level there are multiple SAS data set created. <BR /> <BR /> We would like to allow users access to the data at the project folder level and allow them to drill down to folder containing project/hierarchy level data. In EG, we can look at the server view and see libraries and files. We can expand files and find the project directory/hierachy level desired. However, in AMO when we open a data source from server the only thing we seem to have access to is defined libraries. Why? What are we missing ? How do we make this work for the AMO users?<BR /> <BR /> (Defining a separate library for each project/hierarchy level would be a nightmare) Fri, 27 Oct 2006 19:42:51 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1665#M95 LAP 2006-10-27T19:42:51Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1666#M96 Hi,<BR /> <BR /> You didn't say whether you are using the Forecast Studio Open Project wizard within SAS Add-In for Office. Are you? You should be able to open a hierarchical project from there.<BR /> <BR /> Chris Tue, 31 Oct 2006 18:02:26 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1666#M96 ChrisHemedinger 2006-10-31T18:02:26Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1667#M97 I'm not sure what the Forecast Studio Open Project wizard is or how to get to it....? <BR /> <BR /> I don't see anything my menus. Do I have to do something in Management Console? Wed, 01 Nov 2006 19:09:21 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1667#M97 LAP 2006-11-01T19:09:21Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1668#M98 I found the Forecast Studio Open Project Wizard but am getting errors..<BR /> <BR /> "There was an error attempting to run the 'Forecast Studio Open Project' task:<BR /> <BR /> A Forecasting session cannot be extablished: The underlying connection was closed: The connection was closed unexpectedly."<BR /> <BR /> Not sure what this is as I can see and open data in my library definitions on the same server. Wed, 01 Nov 2006 19:28:40 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Using-AMO-to-access-project-files-from-Forecast-Studio/m-p/1668#M98 LAP 2006-11-01T19:28:40Z