Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

...

Once you have datasets, you can create relationships among the different datasets. 

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • From Kyvos 2024.10 onwards, you can view the user list, group list, or both in the access right dialog box while sharing an entity with other users or groups.

  • Users with data designer roles and access to underlying data tables can create data relationships.

  • If the  ALLOW_ENTITIES_ON_ROOT property is set to  Yes, the New  option is displayed, which is used to add any Kyvos entity to the Root folder. The  New  option is displayed beside the  Quick Data Modelling  option. Conversely, if it is set to  No , you cannot add any Kyvos entity to the Root folder, and the  New  option to add the folder is not displayed. 

...

Info

Note

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

Properties

In the Properties pane, you can do the following:

...

In the Relationships pane, you can view or change the relation type. For example, you can change from one-to-many to many-to-many by clicking the blue icon next to the Actions menu (   ), then clicking Yes to confirm the change.

To add a relation, perform the following steps: 

  1. Click the Actions menu (   ) > Add relation and specify a source and target for an outgoing relationship, and then click Apply

  2. To change the incoming or outgoing relationship to one-to-many, click the blue icon next to the Actions menu (  ⋮  ), and then click Change.

  3. To change the operator between a source and a target, click the operator (the blue equal sign in the screenshot shown here) and choose equal to or between. If you choose between you must select a target.

  4. To delete a relationship, click the Actions menu (   ), and then click Delete to confirm the deletion.

...

Click either the Collapse or Expand All Tables in a Relationship icon at the top of the workspace next to Tips to expand or collapse all nodes.

Tabular view

For complex relationships, you can also view and edit the nodes in a table format.  The table format is best used when you have a larger number of nodes, for example, 25.  It helps you avoid additional scrolling and moving relationship lines. You can see all of the information more easily in table format. The table view allows you to more easily search, sort, and filter relationships. 

Once you have made changes using the tabular view, you can't switch back to the graphical view. 

To switch to the tabular view, click the Actions menu (...) and click Switch to Tabular View.

Raw data

You can create relationships using data that hasn't been processed into a semantic model. Select the file you want to use and create relationships using it. See Working with non-materialized or raw data semantic models 

...