When you use this method to create individual fact tables, all columns in the source table or view are assigned to a single fact table and if the source has relationships with other tables or views, we'll offer to add them to your model.Īfter locking the model, perform one of the following actions to create fact tables individually: Creating a fact table based on source views provides greater flexibility than using source tables directly. If the data that you need has not yet been loaded into the database, then you can load it.Ĭreate source views as a base for model objects when you think you might want to perform subsequent changes like extending model objects, creating filters, and adding pre-aggregation calculations. If you think the list of source objects in the database has changed since you opened Data Modeler, then you can click Refresh from the Database Actions menu. Also ensure that you have created any source views upon which to base model objects. See Components of Data Models.īefore you begin modeling fact tables and dimension tables, make sure that the data that you need to model is available in the source tables list. For example, Customer Name, Region, and Address are attribute columns.įact tables and dimension tables represent the aspects of your business that you want to understand better. For example, Revenue and Units are measure columns.ĭimension tables contain attributes that describe business entities. Fact tables and dimension tables hold the columns that store the data for the model:įact tables contain measures, which are columns that have aggregations built into their definitions.