Top FAQs to Model Data

The top FAQs for data modeling are identified in this topic.

Can I use the same data for different analyses?

Yes. You can create source views that expose the same source columns in different contexts. You use views to include the same source objects in multiple dimensions. For example, to use time data for both the Order Date and Ship Date dimensions, create two views based on the time source table, time_order_date_v and time_ship_date_v. The views can then be used as sources for the Order Date and Ship Date dimensions.

After I add new columns to my source table, can I include the new columns in my data model?

Yes. You can include newly added source columns. To include the new columns, select Synchronize with Database from the Actions menu for the appropriate fact table or dimension table in the Data Model. Then, in the messages list, select the message item describing the new columns and select Sync-up selected from the Message Actions menu.

In what situations should I create model objects based on source views?

Always create a source view when you think that you might want to perform subsequent changes, such as extending model objects, creating filters, and adding calculations. Creating a model based on source views provides greater flexibility than using source tables directly.

Can I include columns from a different source table or view in my existing dimension table when it is based directly on a source table?

Yes. It's easy to add columns from another source table or view to an existing dimension table. To do this, drag and drop the table or view on to your existing dimension table. See Adding Columns from Another Source to a Dimension Table.

Can I include columns from a different source table in my existing dimension table when it is based on a source view?

Yes. There are two ways you can do this. You can drag and drop the table on to the dimension table to include the columns. Alternatively, edit the view to include the new source columns, and synchronize your dimension table with your changes to the database. Synchronization identifies new columns in the view and adds them to your dimension table.

Can I create a source view that is based on another source view?

Yes. To do this, drag and drop the source view to the Columns area of the Overview tab when creating the view, or select a source view from the Add Columns dialog as your source.

For example, assume that you have both time and time_fiscal source tables. You created a view called time_v that combines time and time_fiscal. You want to create multiple dimensions that are based on time data, such as Order Day and Ship Day. You first create the Order Day dimension based on time_v, and then you create a separate view on top of time_v to create Ship Day. (Note that another option is to create a parallel view called ship_day_v that also combines time and time_fiscal.)

Can I migrate my data model from one environment to another?

Yes. Take a snapshot of your environment and migrate it to the new environment. See Take Snapshots and Restore.

Can I localize analyses and dashboards that are stored in the catalog?

Yes. Follow the procedure Localize Catalog Captions.

Can I edit my data model in the Cloud?

Yes. See Edit a Data Model in the Cloud.

Can I load a data model RPD file from Oracle BI Enterprise Edition?

Yes. If you’ve modeled your business data with Oracle BI Enterprise Edition, then you don't need to start from scratch in Oracle Analytics Cloud. Instead of using Data Modeler, you can use BI Developer Client Tool to upload and edit your data model RPD in the cloud. See About Editing Data Models Uploaded from Oracle BI Enterprise Edition.