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

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.
主站蜘蛛池模板: 枣庄市| 康平县| 巴青县| 根河市| 隆昌县| 福贡县| 汾阳市| 彩票| 遵义市| 曲阜市| 金溪县| 许昌县| 和龙市| 库尔勒市| 祥云县| 兴城市| 西乌| 宜都市| 平谷区| 内江市| 正镶白旗| 赤峰市| 胶南市| 南宁市| 娱乐| 全南县| 宁夏| 会宁县| 马鞍山市| 始兴县| 延津县| 葵青区| 焦作市| 宁陵县| 赤水市| 印江| 鄂伦春自治旗| 黔西县| 关岭| 邵阳县| 房产|