- Learning SAP Analytics Cloud
- Riaz Ahmed
- 285字
- 2021-07-02 19:52:13
Selecting a source file
You can import data from an external file, such as an Excel spreadsheet or a comma-separated-values file, into a new model. If the data is saved in separate sheets in the Excel workbook, you will see a drop-down list from where you can choose which sheet to import:

The source data must include columns that can be used to create dimensions in a new model, and it must also include transactional data (measures). The transactional data is not visible in modeler, only in the output that is generated.
You can connect to other systems to create a new model from an external source. To connect to such external sources, you have to select the use a datasource or get data from an app option. You can also create a model manually by setting up the dimensions individually and defining all the preferences and details of the model exactly as you require. You can create a model using the templates available in the planning wizard available within when you add a table to a story.
Note that some of these model creation options are not available in the trial version. So, in order to keep things simple, you are creating the model using an Excel file. The Bocage.xlsx file is a simple Excel file being provided with this book for demonstration purpose. It contains measures data (Quantity sold, Sales Revenue, Gross Margin, Discount, and Original Sales Price) to gauge the performance using date, state, city, store, manager, product, and category dimensions. In addition to measures and dimensions, the file has two columns (latitude and longitude) that will help you to visualize data in geo maps. This file can be downloaded from https://github.com/PacktPublishing/Learning-SAP-Analytics-Cloud.
推薦閱讀
- Hyper-V 2016 Best Practices
- Modular Programming with Python
- Java入門(mén)經(jīng)典(第6版)
- Raspberry Pi Networking Cookbook(Second Edition)
- 匯編語(yǔ)言程序設(shè)計(jì)(第3版)
- 程序員修煉之道:通向務(wù)實(shí)的最高境界(第2版)
- 精通MATLAB(第3版)
- 軟件測(cè)試實(shí)用教程
- 軟件測(cè)試綜合技術(shù)
- Vue.js 3應(yīng)用開(kāi)發(fā)與核心源碼解析
- Flink核心技術(shù):源碼剖析與特性開(kāi)發(fā)
- Practical Responsive Typography
- 少年小魚(yú)的魔法之旅:神奇的Python
- JSP編程教程
- 狼書(shū)(卷2):Node.js Web應(yīng)用開(kāi)發(fā)