Dimensions attributes attribute relationships hierarchies và cube là gì năm 2024

• A hierarchy is a useful tool in SSAS to reduce complexity.
• In the last article, I have created a cube now we learn about dimensional hierarchy.
• Firstly we create a supplier table in SQL Server also give foreign key relationship with the fact table. SUPPLIER TABLE
• In the supplier table, Suppliers 1 and 2 work under the Boss1 and suppliers 3 and 4 work under the Boss2. TABLES
• For self-referencing, we edit the table→ In the Query designer → we select the Diagram under the Pane option.
• Then we add supplier table by right-clicking on the white space area.
• We create a new relationship by removing an existing relationship. SalesPersonBossId from DimSupplier1 connects to SupplierId in the DimSupplier table. SEIF REFERENCE THE TABLE
• Now we apply left join on these tables. Then we select all rows and right-click on the relationship choose to Select All Rows From Dim Supplier.
• Now we execute this query in SSAS. QUERY
• Goto the SSAS Data Source Views → Right click on white space area → And add New Named Query.
• We enter the name as DimSupplier and that query paste on here and execute it. NAMED QUERY
• When we click on ok then create a named query. DimSupplier is a query and others are the tables.
• Refresh the data source view and create a relationship between fact and the supplier table.

  CREATE DIMENSION

• Right-click on Dimensions → New Dimensions. Using this wizard we create a new dimension. DIMENSIONAL WIZARD
• In Select Creation Method wizard, we use an existing table. SELECT CREATION METHOD
• Check the name of the data source view and select the name of the main table then click on Next. SPECIFY SOURCE INFORMATION
• Specify Attribute Name as SupplierId and click on Next. SELECT DIMENSIONAL ATTRIBUTE
• Verify the name and click on Finish.

  COMPLETE THE WIZARD

  ADD DIMENSION

• After that, we add all the three fields of DimSupplier.dim from the data source view to attribute. Also, we add in the cube. ADD DIMENSION
• Goto Cube (SSAS Database.cube)→ In the dimensions right-click on dimensions cube (SSAS Database) → Select “Add Cube Dimension” option → Select the supplier table → And click on OK.

  ADD DIMENSION

  LINK WITH DIMENSION

• Dimension usage tells that how to dimensions connected to measures. DimSupplier connected to fact table via SupplierId. DIMENSION USAGE
• Here we define Dimensional Hierarchies. The attribute relationship shows the relationship according to hierarchy.
• Now we drag and drop attributes into the hierarchies. At the top-level define Boss and below boss we define the Supplier. HIERARCHY
• Then we link Boss with the SalesPersonBossId. To linking we right-click on Boss property. LINK DIMENSIONS
• And here we link Supplier with SupplierId. LINK DIMENSIONS
• In Attribute Relationship create a visual structure. ATTRIBUTE RELATIONSHIP
• After that, we process a cube and Reconnect to a cube. In below query, we display Boss, Supplier and Amount. BROWSER TAB
• We create a hierarchy because of not only a visual structure but also there are any calculative fields like Amount we can total it. QUERY IN EXCEL

Start with MSBI video as mentioned below to learn topic practically in-depth:

Unity uses the concept of parent-child hierarchies, or parenting, to group GameObjects. An object can contain other GameObjects that inherit its properties.You can link GameObjects together to help move, scale, or transform a collection of GameObjects. When you move the top-level object, or parent GameObject, you also move all child GameObjects.

You can also create nested parent-child GameObjects. All nested objects are still descendants of the original parent GameObject, or root GameObject.

Child GameObjects inherit the movement and rotation of the parent GameObject. To learn more about this, see documentation on the Transform componentA Transform component determines the Position, Rotation, and Scale of each object in the scene. Every GameObject has a Transform. More info See in .

Organize GameObjects

Create new GameObjects

To create a new GameObject in the Hierarchy window:

1. Right-click on empty space in the selected Scene.
2. Select the GameObject you want to create.

You can also press Ctrl+Shift+N (Windows) or Command+Shift+N (macOS) to create a new empty GameObject.

Note: New GameObjects are created in “rename” mode automatically. To disable this behavior, select the More (⋮) menu in the Hierarchy window and deselect Rename New Objects.

Toggle child GameObject visibility

To toggle the visibility of child GameObjects:

1. Select the drop-down arrow (►) to the left of the parent GameObject.
2. Press Alt while clicking the drop-down arrow (►) to toggle visibility of all descendant GameObjects of the root GameObject.
3. Select the drop-down arrow again (▼) to collapse all descendant GameObjects.

Create child GameObjects

To create a child GameObject:

• Drag the GameObject onto the parent GameObject in the Hierarchy.
  
  Object 4 is selected and is being dragged onto Object 1, so Object 4 can become a child of Object 1.

Create parent GameObjects

You can add a new GameObject into the Hierarchy view as the parent of existing GameObjects.

To create a parent GameObject:

1. Right-click a GameObject, or select multiple GameObjects on the same level and right-click.
2. Select Create Empty Parent.

You can also press Ctrl+Shift+G (Windows) or Command+Shift+G (macOS) to create a parent GameObject.

Note: If you have set a default parent GameObject, Create Empty Parent creates the new GameObject as a child of the default parent, not as the parent of the selected GameObjects.

Create sibling GameObjects

A sibling GameObject is a GameObject with the same hierarchy as another child GameObject. To create a sibling GameObject:

1. Drag the GameObject above or below an existing GameObject.
2. Use the horizontal blue line to determine the order of the GameObject.
   
   Drag Object 4 (selected) between Object 2 and Object 3 (indicated by the blue horizontal line), to create a sibling GameObject under the parent GameObject Object 1 (highlighted in a blue).

Duplicate GameObjects

To duplicate GameObjects, right-click the target GameObject and select Duplicate.

You can also press Ctrl+D (Windows) or Command+D (macOS) to duplicate the selected GameObject.

Paste GameObjects as child

You can cut or copy a selected GameObject and then paste it as a child of another GameObject. Pasted child GameObjects keep their world position.

To paste a GameObject as child:

1. Right-click the selected GameObject, and then select Cut or Copy.
2. Right-click the intended parent GameObject, and then select Paste as Child.

You can also press Ctrl+Shift+V (Windows) or Command+Shift+V (macOS) to paste a GameObject as a child.

Organize GameObjects with default parent

You can make any GameObject in the Hierarchy window a “default parent”. When you drag a GameObject into the Scene view, Unity automatically makes this GameObject the child of the GameObject you set as the default parent.

To make a GameObject a default parent:

1. In the Hierarchy window, right-click on the GameObject.
2. Select Set as Default Parent.

When you drag a GameObject into the Scene view, in the Hierarchy window, the child GameObject is indented below the default parent GameObject. The name of the default parent GameObject is bold.

To remove default parent status from a GameObject:

1. In the Hierarchy window, right-click on the GameObject.
2. Select Clear Default Parent.

The name of the GameObject that was previously the default parent is no longer bold. When you drag a GameObject into the Scene view, it appears at the top level in the Hierarchy window. In other words, Unity does not make this GameObject the child of the GameObject that was previously the default parent.

You can only set one default parent per Scene. In the Hierarchy window, if you set a GameObject as the default parent, and then you make a different GameObject in the same Scene the default parent, only the second GameObject is the default parent.

If you have multiple Scenes in the Hierarchy window, and you set default parents in each Scene, when you drag a GameObject into the Scene view, Unity makes the default parent GameObject in the active Scene the parent of the new GameObject.

You can set a keyboard shortcut for the default parent setting in the Shortcuts manager. On the Shortcuts window, assign a keyboard shortcut to Hierarchy View > Set as Default Parent. If there is no default parent set, and in the Hierarchy window you select a GameObject, use the shortcut to make this GameObject the default parent. When a default parent is set, use the shortcut to remove default parent status from any GameObject that has it.

Set Scene visibility and pickability

Click the Scene visibility icon to hide and show GameObjects in the Scene viewAn interactive view into the world you are creating. You use the Scene View to select and position scenery, characters, cameras, lights, and all other types of Game Object. More info See in without changing their in-application visibility.

Select the Scene picking icon to toggle the ability to select GameObjects in the Scene view while you are editing.

These controls are useful for working with large or complex Scenes where it’s difficult to view and select specific GameObjects.

For more information, see the documentation on Scene visibility and Scene picking.

Sort GameObjects

By default, the Hierarchy window lists GameObjects in the order they’re created. You can drag the selected GameObject up or down in the Scene to change the order of the GameObjects.

Alphanumeric sorting

To sort GameObjects in alphanumeric order:

1. Select Edit > Preferences (macOS: Unity > Settings).
2. Select Enable Alphanumeric Sorting.

When selected, an icon appears in the Hierarchy window that allows you to toggle between Transform sorting (the default value) or Alphabetical sorting.

Multi-Scene editing

You can have more than one Scene open in the Hierarchy window at the same time. For more information, see the Multi Scene Editing page.