SAP Knowledge Base Article - Public

2957386 - [How-to] Export the output dataset of Smart Predict model to a csv file?

Symptom

  • [How-to] Export the output dataset of Smart Predict model to a csv file?
  • The applying result from Smart Predict model is mainly a dataset, how to export the data to a csv file or a flat file?

Environment

  • SAP Analytics Cloud (SAC)
  • Smart Predict

Reproducing the Issue

  1. Logon to SAC.
  2. Create a new Predictive Scenario.
  3. Choose Classification model type.
  4. Create and save the model.
  5. Click Apply Predictive Model.
  6. Select a new Input Dataset.
  7. Set other necessary elements and filed for the applying dataset.
  8. Click OK and run applying.
  9. Output Dataset is generated in SAC as a Dataset.

Resolution

  • Option 1 (Recommended) : Consuming the dataset into a Planning model, then export the model Data.
    1. Create a model (from the main menu Create -> Model).
    2. Select Get data from a datasource.
    3. From the proposed list, select Dataset and browse up to your generated dataset.
    4. Exporting a Model to a File.
      Note, Live data model cannot export data to local.
  • Option 2 : Create a Story with Crosstab, then export the Crosstab data.
    1. Create a Story with any format. 
    2. Add a Crosstab into the Story.
    3. Click the ... on the top right of the Crosstab, choose Export.
    4. Save the data to a csv file.

See Also

Keywords

PA, Infinite insight, test sub-set, training a model, classification, time series, regression, plain format, text file
, KBA , LOD-ANA-PR , SAC Predicitive , BI-RA-PA , Predictive Analytics , How To

Product

SAP Analytics Cloud 1.0