Create a Dimension Alias

Dimension alias are alias names on the warehouse dimension tables. You can specify the alias names for the Dimension type augmentations and the data that's in the warehouse already as dimensions. The alias names enable you to reuse the existing warehouse tables with different names in the subject areas.

You create dimension aliases as a type of augmentation. This is useful when you want to reinstate a dimension for analysis. For example, if you would like to reuse the Vendor dimension as a Shipper dimension as well, you can create an alias for Vendor.

You can also select complex custom attributes as dimension aliases and retain the name defined in NetSuite. Ensure that you enable Dimension Alias in the Custom Attribute Mapper section under the Preview Features tab on the Enable Features page.

When you create the aliases, Oracle NetSuite Analytics Warehouse doesn’t copy the data for the dimension aliases. These augmentations don’t have a pipeline status, but they are visible in the subject area.

  1. Sign in to your service.
  2. In Oracle NetSuite Analytics Warehouse Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Configurations, click Data Augmentation.
  4. On the Data Augmentation page, click Create, and select Dimension Alias.
  5. In the Add Dimension Alias dialog, in Source Dimension, select a dimension from the source tables such as Employee.
  6. In Dimension Alias, enter a name such as Shipper Dim.
    In Table Name, Oracle NetSuite Analytics Warehouse displays the name such as DW_FA_X_SHIPPER_DIM.
  7. In Subject Areas to expose alias, select one or more subject areas from the subject areas where the original source dimension exists.
  8. Add a description of the dimension alias.
  9. Click Save.