<p>about your learning experience to help us improve.</p>

You've completed

cleanFiles/bookmap_Pointing_out_Advanced_SAP_Analytics_Cloud__en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2024-10-17T12:22:33.000Z

Importing Additional Data Sources

<div id="content"><div class="parentsection"><div class="section"><div tabindex="0"><h3>In addition to using data models to import SAP Sports One data, is it also possible to import other data sources and include them in my story? What kind of data sources can be integrated?</h3></div><p tabindex="0">In addition to SAP Sports One data, you can integrate data from various sources, such as other SAP systems or external sources like Excel files.</p><p tabindex="0">The following video provides a comprehensive answer to your question.</p><div class="kalturaVideoLessonWrapper"><div aria-label="" class="kalturaVideoLessonContainer" data-testid="video" id="1_hlm4lfkx"></div></div></div></div></div>

Additional Data Sources

Answering Frequently Asked Questions for SAP Analytics Cloud for the Sports Industry

<div>Learn how to integrate multiple data sources, including SAP Sports One and Excel sheets, into your SAC stories. Explore data modeling, importing, and linking techniques for a comprehensive analysis.<br><br># This description was auto-generated #</div>

You can incorporate multiple data sources to analyze your SAC stories. Let's start by using a basic live connection to integrate SAP Sports One data. In the Connections section, you'll find an overview of all existing connections, including the one of your SAP Sports One system. You can find an overview of all models for SAP Sports One data integration in the Models folder located in the Public Directory. Additionally, you can include new data sources, such as Excel sheets. To integrate this new data source, navigate to the Modeler tab to create a new model. Select the option Start with Data, since there is already a flat file, the Excel sheet, with data available. In the Data Source Overview, you'll see many data sources available. We'll focus on file import, so select File, Local File, or File Server. Nevertheless, you can also add data sources from other SAP solutions and databases. After selecting the File Import option, choose your local file from the desktop. You can decide whether the first row of the file should be used as column headers, which will define the measures and dimensions of the model. By selecting this option, the measures and dimensions will be automatically generated in the model. We can now adjust the model in the workspace by adding new measures or dimensions using the edit section. If you need to load a large data set, you can add variables to your model similar to the process used in SAP Sports One import models. After creating all measures and dimensions, either through upload or manually, you can make adjustments as needed. Be sure to save your model after setting up all the information. To update the model's data, go to the Data Management tab in the workspace and upload the new Excel file. Click on Set Import to initiate the import process. On the left side, you'll find the data from the uploaded file. Next, ensure completeness in model and file mapping by verifying the correct mapping of all dimensions and measures. Also, ensure that the import process requires no additional actions and encounters no issues before proceeding with and completing the import. Once the import is is complete, you'll be able to view the latest status and check if the import job was successful. You can now integrate data from various sources into a single story by using the available models. Initially, we've integrated the internal team members model for SAP Sports One data. Additionally, we've incorporated the data of the custom model on Jersey sales into the story. You're now able to utilize these two data models similar to what you're familiar with from SAP Sports One import models. For example, you can create model linking between the models and tailor stories according to your own preferences. Please note that additional details regarding advanced SC features are available in other learning videos of this course.