SAC - Convert Dataset to Model

In SAP Analytics Cloud (SAC), converting a dataset to a model involves several steps. SAC models are used to define the structure of your data for analytics, whereas datasets are typically flat files or source system extracts. To convert a dataset to a model, follow these steps:

Steps to Convert a Dataset to a Model in SAC:

1. Login to SAC: Log into your SAP Analytics Cloud system.

2. Go to the Modeler:

   • Click on the "Main Menu" in the top-left corner.
   • Navigate to "Create" and then select "Model".

3. Select the Data Source: In the "Modeler," you have multiple options for data sources:

   • File Upload (CSV, Excel)
   • Live Data Connection (SAP HANA, BW, etc.)
   • Acquired Data (import data from other sources like SAP S/4HANA, SQL, OData, etc.)

   For converting a dataset, you will likely choose "Import Data from File" or connect to a data source.

4. Upload the Dataset:

   • Click "From a File" to upload your dataset if it's in a CSV or Excel format.
   • Choose the dataset from your system and click "Open".

5. Map Dataset Columns to Model Dimensions and Measures:

   • SAC will automatically map columns as dimensions (text, dates, categories) or measures (numeric values).
   • You can manually adjust these by:
     • Marking fields as "Dimension" or "Measure".
     • Assigning types (date, number, text, etc.) to the dimensions and measures.
     • Creating hierarchies if applicable (for example, geographic or organizational hierarchies).
     • Adding attributes for dimensions if necessary.

6. Define Dimensions and Measures:

   • Add any additional dimensions, measures, or hierarchies that are missing or need refinement.
   • Review and rename dimensions and measures for clarity and accuracy.

7. Data Preparation (Optional):

   • You can use data wrangling tools to clean up your dataset, such as handling missing values, transforming data types, etc.
   • Use the "Transformations" tab to perform operations like calculations or data filtering if needed.

8. Save the Model:

   • Once the data mapping and transformations are done, click "Save".
   • Name your model and click "OK".

9. Create Stories or Reports:

   • Once the model is saved, you can use it to create SAC stories, dashboards, or reports.
   • Go to Stories, select the model, and begin visualizing the data through charts, tables, or other analytics components.

Key Considerations:

• Measures vs. Dimensions: Ensure that numeric fields intended for analysis are marked as measures, and categorical fields are marked as dimensions.
• Data Wrangling: You might need to perform some data cleaning or transformation before finalizing your model.
• Versioning and Updates: If the underlying dataset changes, you can update the model by importing updated data.

By following these steps, your dataset will be converted into a model, ready for analysis and reporting in SAP Analytics Cloud.