- Learning SAP Analytics Cloud
- Riaz Ahmed
- 240字
- 2021-07-02 19:52:16
Private dimensions
Private dimensions exist only in the current model and don't appear in the public dimensions list. When you create dimensions while importing data from a file or from SAP Business Warehouse, SAP ERP, SAP Universe, or other databases, they are created as private dimensions. When you delete a model, private dimensions in that model are also deleted, but the public dimensions are not. All dimensions have, at minimum, both description and ID attributes. Typically, for each dimension, the imported data column is used as the dimension's description attribute. An ID column is then automatically generated for each dimension to contain the unique IDs of the rows:

Recall that in creating a Location dimension section at step 13, we set the Store column as its location identifier and specified the Latitude and Longitude columns. The model creation process accumulated all that information here under the Store tab, which will enable you to visualize the data in geomaps:

You created a hierarchical relationship between the Category and Product columns in steps 16 to 20. You can see that relationship under the Product tab. For example, the Coconut Water product has been linked to the Others category. The same hierarchical relationship is presented in the blue Preview panel on the right side:

- Learning Neo4j
- Python神經(jīng)網(wǎng)絡(luò)項(xiàng)目實(shí)戰(zhàn)
- CKA/CKAD應(yīng)試教程:從Docker到Kubernetes完全攻略
- Functional Kotlin
- Learning Apache Mahout Classification
- Learning FuelPHP for Effective PHP Development
- QGIS 2 Cookbook
- Python程序設(shè)計(jì)開發(fā)寶典
- Oracle Data Guard 11gR2 Administration Beginner's Guide
- IPython Interactive Computing and Visualization Cookbook
- 面向?qū)ο蟪绦蛟O(shè)計(jì)及C++(第3版)
- DevOps 精要:業(yè)務(wù)視角
- PostgreSQL 12 High Availability Cookbook
- Head First Kotlin程序設(shè)計(jì)
- VMware vSphere Design Essentials