Copying Model Objects

Sometimes it’s quicker to copy objects rather than starting from scratch.

In Data Modeler you can copy fact tables, dimension tables, database tables, and database views:

  • Fact tables

    To copy an existing fact table, select Duplicate from the Fact Table Actions menu. When you copy a fact table, Data Modeler includes joins by default. See Creating Fact Tables Individually.

    Aggregation level settings for measures aren’t copied as, in most cases, level settings in the original fact table and the copied version differ. After copying a fact table, review and set the aggregation levels for measures as required.

  • Dimension tables

    To copy an existing dimension table, select Duplicate from the Dimension Table Actions menu. When you copy a dimension table, Data Modeler excludes joins default. See Creating Dimension Tables Individually.

  • Database tables and views

    To copy an existing database object, select Duplicate from the Actions menu. When you copy a table or view, Data Modeler creates a view based on the table or view you copy. See Defining Source Views.