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

Time for action – creating a hierarchy

In this example, we will see how a user can create hierarchies in the browser and how a developer can create a predefined hierarchy for business requirements by performing the following steps:

  1. Go to the cube Browser, drag-and-drop Calendar Year, Month, and Date, one after another. Then, drag-and-drop Sales Amount and Order Quantity. You will see a hierarchy created dynamically from the browser.
  2. Now, go to the product's Dimension Designer, drag-and-drop the EnglishProductCategory name into the Attributes pane, and rename it Product Category. Do the same for EnglishProductSubcategoryName and rename it Product Subcategory. Rename the Product Key attribute Product and change its name column to EnglishProductName.
  3. Drag-and-drop Product Category from the Attributes pane into the Hierarchies pane.
  4. A new hierarchy will be created; rename it Product Category Hierarchy.
  5. Drag-and-drop the product Subcategory under the Product Category option (in the <new level> area), and then add Product under that.
  6. Select Product Category and change the AttributeHierarchyVisible option of this attribute to false. Do this for the Product Subcategory and Product attributes as well.
  7. In the Dimension browser, you will see that only Product Category Hierarchy is listed, and the values of this hierarchy have created a tree of Product Category, Subcategory and Product.
    Time for action – creating a hierarchy

What just happened?

In this example, you created a user hierarchy easily with just a few drag-and-drops. The hierarchy of this example is created from one table. Creating hierarchies from multiple related tables is as simple as creating a hierarchy from a single table; you just need to import attributes from the Data Source View pane into the attributes area and you can then create a hierarchy based on the attributes.

You also saw that after creating Product Category Hierarchy, we set the visibility of the attributes to false. As the user can access the Product Category, Subcategory, and Product attributes through Product Category Hierarchy, there is no need to have separate attributes. Making them invisible from the user's perspective will reduce the user's confusion with regards to too many attributes.

主站蜘蛛池模板: 福建省| 云安县| 齐河县| 鲁甸县| 连云港市| 沂源县| 惠州市| 巴中市| 三江| 瓮安县| 乐都县| 甘泉县| 宣汉县| 安多县| 连云港市| 怀安县| 栾川县| 讷河市| 合作市| 松桃| 棋牌| 绵阳市| 宜城市| 定西市| 靖江市| 仲巴县| 大名县| 炎陵县| 宜良县| 金塔县| 南通市| 孝昌县| 四子王旗| 双牌县| 黄大仙区| 关岭| 翼城县| 沁源县| 平泉县| 桐乡市| 满洲里市|