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

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:


When you make any changes to your model in the modeler (for example, changing filters in the Time dimension), click on the Save icon (A) to preserve your changes.
主站蜘蛛池模板: 禄劝| 宁阳县| 霍州市| 中江县| 子洲县| 凤冈县| 古浪县| 刚察县| 益阳市| 衡山县| 平乐县| 织金县| 六枝特区| 沛县| 临安市| 醴陵市| 鄢陵县| 铜山县| 怀柔区| 井陉县| 鱼台县| 芦溪县| 沾化县| 顺昌县| 沭阳县| 禹城市| 榆中县| 漳平市| 六盘水市| 灵石县| 广元市| 车险| 新宁县| 枣强县| 金堂县| 犍为县| 鄂尔多斯市| 贺兰县| 南靖县| 攀枝花市| 本溪市|