- 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:

- Mastering Visual Studio 2017
- Design Principles for Process:driven Architectures Using Oracle BPM and SOA Suite 12c
- Python數(shù)據(jù)可視化:基于Bokeh的可視化繪圖
- 營(yíng)銷(xiāo)數(shù)據(jù)科學(xué):用R和Python進(jìn)行預(yù)測(cè)分析的建模技術(shù)
- Java程序設(shè)計(jì)與計(jì)算思維
- MySQL數(shù)據(jù)庫(kù)管理與開(kāi)發(fā)實(shí)踐教程 (清華電腦學(xué)堂)
- 量化金融R語(yǔ)言高級(jí)教程
- NGINX Cookbook
- Multithreading in C# 5.0 Cookbook
- 智能搜索和推薦系統(tǒng):原理、算法與應(yīng)用
- Oracle Database XE 11gR2 Jump Start Guide
- HTML5與CSS3權(quán)威指南
- Python數(shù)據(jù)預(yù)處理技術(shù)與實(shí)踐
- Instant AppFog
- 流暢的Python