Physical view

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

The initial user designs a semantic model to meet their business requirements. Over time, this design is changed while tuning the semantic model to optimize the semantic model process time or to improve the query response time. In such cases, the initially created business design gets lost. To overcome this, Kyvos enables you to design the logical and physical semantic model separately. Using this feature, the semantic model designers can change the physical design according to optimization requirements while retaining the business or logical view.

Points to remember:

• The physical view is a separate view of the semantic model that lets you make changes over time to tune the performance of a semantic model without losing the business design or logic design of the semantic model.

• The physical view is used to make changes that improve query performance or optimize semantic model process time. The physical view is a replica of the logical view except for the calculated measures and calculated members, which only exist in the logical view.

• When you make changes to the logical view, those changes are replicated in the physical view. In most cases, after you make changes, you will need to do a full build of the semantic model.

• The items you add and modify are displayed in different colors so you can easily see the changes you make. 

• You can validate the physical view, do data profiling, and use sliding windows and drop partitions with physical views.

• You can also get recommendations for the physical view.

To display the physical view, perform the following steps.

1. From the Toolbox, click Semantic Models.

2. Select a semantic model from the list.

3. Click the Refine tab, and select Physical View.

Open

To use physical view recommendations, perform the following steps. 

1. From the Toolbox, click Semantic Models.

2. Select a semantic model from the list.

3. Click the Refine tab, to confirm you are looking at the Physical View.

4. Click Recommend me at the top right of the work area. 

5. In the Recommend Physical View dialog box, you can search for or select from the items shown.

6. You can also click the Show All Dimensions checkbox to view the complete semantic model design.

7. On the right of the window, you can see recommendation details.

8. Click Show Reasons to see additional information.

9. Click Hide Reasons to hide them.

10. At a glance, you can view what will be added, modified, moved, or deleted. 

11. Click Accept to make the recommended changes. 

Open

Working with the physical view

To use any of the facts or dimensions from a many-to-many dataset, you must create a bridge dimension in the Physical view. See Working with many-to-many relationships.

Types of changes you can make:

• Move attributes from one dimension to another existing dimension or a new dimension using drag and drop operation

• Add dimensions

• Move an attribute of a dimension (for example, Dim1) to be a single level in a different dimension (such as Dim2) so that it will be materialized using the drag and drop operation.

Limits to what you can do in the physical view:

• You can move attributes from similar dimension types only. For example, you can move attributes from a Time type dimension to another Time type dimension. Similarly, you can move attributes from the Location type dimension to the Location type dimension.

• You cannot break or make a hierarchy in a dimension.

• You cannot change the property of dimension or level or attribute, such as the display name.

• You cannot delete dimensions created in the logical view in the physical view, but you can delete a dimension that belongs only to the physical view.

• You cannot make changes to SCD type dimensions.