{"id":39164,"date":"2026-07-08T16:52:10","date_gmt":"2026-07-08T15:52:10","guid":{"rendered":"https:\/\/developers.ila.cegid.com\/vision\/\/"},"modified":"2026-07-17T17:09:49","modified_gmt":"2026-07-17T16:09:49","slug":"independent-and-related-datasets","status":"publish","type":"vision","link":"https:\/\/developers.ila.cegid.com\/en\/vision\/documentation\/data-model\/article\/independent-and-related-datasets","title":{"rendered":"Independent and related datasets"},"content":{"rendered":"

A dataset is the data source of a widget in a Vision dashboard. You can create as many datasets as needed, but it’s important to keep in mind how information is organized between them.<\/p>\n<\/div><\/section>\n

Independent datasets<\/h2>\n

Each dataset is independent<\/strong> of the others.<\/p>\n

Unlike other data models, Vision doesn’t use star or snowflake-type structures. Each dataset must contain all the information<\/strong> the widget needs to display its data, since a widget can only have one dataset as its data source.<\/p>\n

If the data comes from a star-type relational model, it must be transformed into a flat structure so that the Vision dataset contains all the information needed for the visualization.<\/p>\n<\/div><\/section>\n

<\/div><\/div><\/div>\n

Star model transformed into independent datasets<\/em><\/p>\n<\/div><\/section>\n

Related datasets<\/h2>\n

In some cases, several datasets can share the same business logic and, as a result, contain common information.<\/p>\n

For example, an Events<\/strong> dataset may have a related Actions<\/strong> dataset, where an event has one or more associated actions.<\/p>\n<\/div><\/section>\n

<\/div><\/div><\/div>\n

Relationship between two entities with common fields<\/em><\/p>\n<\/div><\/section>\n

When two datasets contain common information, the shared fields can be identified in two ways:<\/p>\n

    \n
  • By assigning the same identifier<\/strong> to the same field<\/strong> in each dataset where it appears;<\/li>\n
  • By setting up a relationship or field mapping<\/strong> between different datasets in the dashboard where they are used.<\/li>\n<\/ul>\n<\/div><\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2254,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","tags":[],"post-type":[],"categoria-vision":[1075],"class_list":["post-39164","vision","type-vision","status-publish","format-standard","hentry","categoria-vision-data-model"],"_links":{"self":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/vision\/39164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/vision"}],"about":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/types\/vision"}],"author":[{"embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/users\/2254"}],"replies":[{"embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/comments?post=39164"}],"version-history":[{"count":0,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/vision\/39164\/revisions"}],"wp:attachment":[{"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/media?parent=39164"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/tags?post=39164"},{"taxonomy":"post-type","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/post-type?post=39164"},{"taxonomy":"categoria-vision","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/en\/wp-json\/wp\/v2\/categoria-vision?post=39164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}