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

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.
主站蜘蛛池模板: 阿瓦提县| 石渠县| 孟津县| 江山市| 丰顺县| 鲜城| 建昌县| 丹江口市| 东方市| 贵州省| 长丰县| 济源市| 安康市| 秦皇岛市| 新巴尔虎左旗| 利辛县| 米易县| 华安县| 芜湖县| 房产| 江口县| 汉寿县| 万年县| 阿鲁科尔沁旗| 阿鲁科尔沁旗| 厦门市| 高安市| 十堰市| 景东| 阳江市| 镇原县| 连江县| 苗栗县| 颍上县| 南江县| 民和| 大田县| 墨脱县| 阿拉善盟| 柳州市| 城固县|