Create a New Shared Table

Use shared tables to link multiple fact tables through a common dimension, to compare records across different tables. This keeps your data model clean and unambiguous and ensures that filters behave correctly across different datasets.

Required Editions

Available in: All editions supported by Data 360. See Data 360 edition availability.
User Permissions Needed
To create a shared table:

Permission set:

  • Data Cloud Architect

AND

Semantic Models object

  1. In Data Cloud, on the Semantic Layer tab, select a data model.
  2. In the canvas, click on a standalone or connected data object.
    The bottom panel with the object settings opens.
  3. Turn on Shared Table.
    The shared icon is added to the data model object to indicate that it includes a shared table.

    Shared Table option enabled