SAS Support Communities

Hi Team,              Recently,we have been exposed to SAS FAW and IO products as a part of implementation.After studying the process,we have few doubts and want to get it clarified to explain to others in simple terms.Experts help is needed. 1) Here we are going to use the forecasted output for inventory optimization.Though there are IO integration jobs to pick up forecasted output,we want to know where exactly this forecasted output resides meaning which table after my forecast plan is run. 2) In IO,we came to know that forecasted output sits in forecast demand table.How does the forecasted output is used by inventory optimization (in business terms)? 3) What is intermittent demand table and what does it contain? 4) How do we define a network?What is the difference between a primary network and a primary route? 5) What is the use of facility item demand table and what data should be populated here? 6) What is total order quantity and total received quantity in facility item inventory table? Is it number of purchase orders raised and receipts? 7) Use of facility item network table? 😎 Meaning and use of Route Item table? 9) How do we account for pipeline inventory once the good in received? 10) What if customer order or purchase order is cancelled?How is it to be processed? 11) What role does customer order,item cost,lead time,distance,demand play in replenishment policies and order suggestions? (lead time,distance may be used in network algorithms) Thanks, Maddy ... View more

Hi Team,              I have been using the SAS Access to R3 interface to connect to SAP tables and successfully registered the required metadata for tables in DI Studio.Though it is fine,when I'm trying to create a join on these SAS views to extract required data, it is failing because internally these physical table names start with "/BI0/XXXXXXXXX" and SAS displays it as "_BI0_XXXXXXXX".I cannot load the entire data into separate tables and then extract as it will eat away my space leading to data duplication.I have tried enabling special characters in physical storage under properties of table,but it was of no use. Please let me how to use these "/BI0/XXXXXXXXX" tables directly in my join.Any help is greatly appreciated. Thanks, Maddy ... View more

Hi Team,               As a part of project requirement,we are trying to connect the DB2 database and creating the DB2 Server for the same.Please let me know what are the exact requirements in this case. After research.I came to know about the Database name,Schema name,User credentials are main requirements which have been collected.Which kind of user credentials are needed in this case?We just want to connect to database and extra data.No manipulation is to be done on the DB2 tables.Do separate user needs to be created in this case? Now during server creation,after datasource(database) details,how do I use the authentication domain?How do we create new one with those user credentials? Next when creating new library,schema is used along with above server.But we are facing the error when we are trying to register the tables as below : "SQL1013N  The database alias name or database name "XXX" could not be found. SQLSTATE=42705" Thinking that,it might be due to some drivers problem,we tried to see the ODBC connectivity and added db2 client driver with same database in SYSDSN. Then it started giving below error during register tables " SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR  PASSWORD INVALID"). SQLSTATE=08001" Not able to understand,where are we going wrong and what is the exact procedure to be followed to connect to Db2.Any reference or explanation will be of great help. Thanks, Maddy ... View more

Hi Team,                I have an input dataset in the format as below : ItemID Itemname itemtype typename itemgroup groupname 1 ABC XXX XXXXXXXX A123 XYZ 2 DEF XXX XXXXXXXX A123 XYZ 3 GHI XXX XXXXXXXX B456 ZZZ I need to know the process where I need to use the SCD type 2 retained key for my primary key which is Item id and surrogate keys for type and group accordingly.How should I process with in a single job.I'm new to DI and not able to get the exact flow here. Also,SCD type 2 sometimes gives an error saying "The variable in the DROP, KEEP, or RENAME list has never been referenced".Please help me. Expected output is itemrk itemid itemname typerk type typename grouprk group groupname 1 1 abc 1 xxx xxxxxxxx 1 a123 xyz 2 2 def 1 xxx xxxxxxxx 1 a123 xyz 3 3 ghi 1 xxx xxxxxxxx 2 b456 zzz ... View more

Hi Team,              I have been working on demand forecasting project and using SAS Forecast Analyst Workbench (FAW) for the same.We were trying to improve the accuracy using Forecast Studio and now planning to go ahead with Consensus Planning for the forecasted output.Could anyone of you,please guide me through the process or some kind of material with all the screen shots on how to go about it using SAS Financial Management. Thanks, Maddy ... View more

Hi, As a part of project,I got the data in CSV file at a certain path.Now,I want to read this file dynamically into SAS DI Studio to process further.How should I design a job which runs periodically reading this file from the respective location and registers the file in SAS DI with full data initially and then incremental in later runs. I have an idea of External file Wizard,ODBC connectivity and User written code for complex external files.But,what I want here to completely automate the process of reading file from FTP path into SAS DI by scheduling a job. Please help. Thanks, Maddy ... View more