Select Data Foundation and click Add Objects. Right click on the package you created earlier and select New then Analytic View….Ī new viewing window opens and a folder is added under your package. You should see your new tables under the Tables folder under your schema. For STS_DIMCUSTOMER.csv, select Key for CUSTOMERID. csv files.įor STS_DIMPRODUCT.csv, select Key for PRODUCTID. Repeat steps 1 and 2 to import the remaining two. Click Next to see a preview of your table, otherwise click Finish to complete the upload. Select Key for ORDERID, PRODUCTID, CUSTOMERID, EMPLOYEEID, and ORDERPERIODID. Note: Be sure to select your new schema and not the user you create to ensure that the data is in the proper location.Ĭhoose the Data Types for the table. Select New Schema and choose the schema you created earlier in this series. Select your SYSTEM repository and click Next.īrowse for and select the STS_FCTCUSTOMERORDER.csv file. Select SAP HANA Content then Data from local file. On the SAP HANA Studio window, click File then Import…. Import the STS_FCTCUSTOMERORDER.csv file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |