官术网_书友最值得收藏!

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.
主站蜘蛛池模板: 西安市| 西吉县| 镶黄旗| 桑植县| 河津市| 临海市| 滨海县| 东莞市| 宝清县| 安庆市| 金乡县| 德州市| 鄂伦春自治旗| 新蔡县| 洪泽县| 墨竹工卡县| 琼中| 贺兰县| 颍上县| 尤溪县| 台南市| 金湖县| 紫阳县| 贞丰县| 宣化县| 邻水| 萨迦县| 曲周县| 临颍县| 丰镇市| 乐清市| 吉林省| 岚皋县| 自贡市| 教育| 咸丰县| 娱乐| 嘉善县| 诸暨市| 康保县| 黄浦区|