Extend a Dimension

Extend prebuilt dimensions with additional attributes from another data source.

  1. Sign in to your service.
  2. In Oracle NetSuite Analytics Warehouse Console, click Semantic Model Extensions under Application Administration.
  3. On the Semantic Model Extensions page, click User Extensions.
    You see the main and existing customization branches.
  4. In the User Extensions region, under Customization Branches, click a branch to open the Branch page.
  5. On the Branch page, click Add Step.
  6. In Add Step, select Extend a Dimension.
    You see the wizard sequence to extend a dimension.
  7. Enter a name for your customization step, for example, Add Cost Center Type.
  8. Select a target subject area, for example, Financials GL Profitability.
  9. In Folder, select a dimension that you want to extend, for example, Cost Center.
  10. Select a logical table, for example, Dim – Cost Center.
    You see the available attributes in the table.
  11. Click Next.
  12. Select a schema and table from the database.
    You see the available attributes in the table.
  13. Select the columns that you want to expose or use as a key for creating the join.
  14. Click in the Display Name table field to enter a new name for the column or to edit an existing one and then click Enter to accept or click Esc to cancel.
  15. If any of the selected attributes have been removed or modified in the source table since the last refresh, then you see such columns highlighted and a message asking whether you want to update the table. Select OK in the message to reload the source columns. If you want to review the changes to the source columns, then click Cancel in the message, and later click Refresh to reload the source columns. If any of the attributes that you haven’t selected have been removed or modified in the source table, then you see the refreshed list of source columns. If any of the custom columns fail validation during the refresh, then you see a message asking you to resolve the cause of failure and revalidate.
  16. Optional: Click Create Column to create a new column in the selected dimension table using these instructions:
    1. In Create a new column, enter a display name, for example, Cost Type.
    2. Under Data Elements, search for a data element from the physical table of the selected dimension table.
    3. From the search results, double-click the data element to place it in the text pane.
    4. Under Functions, search for a function to construct a column using expressions. For example, search for functions like "case" to construct new expression-based columns. From the search results, double-click the applicable result to add it to the text pane.
    5. Click Validate, and then click Save.
  17. Click Save.
  18. Click in the Source Column table field to edit the column definition.
  19. Click Save.
    You see the new column in the Data preview section in a highlighted color.
  20. Click Next.
  21. Select a join key to pair with the source column. If you want to provide expressions as join conditions, then click Complex Join and in Create Joins, click Add Joins, select the target and source logical tables, enter the join condition as an expression, and click OK.
  22. Click Next.
  23. Select the subject areas that should use this customization.

    Note:

    The Subject Area that you initially selected is selected by default and is read-only. By default, all additional subject areas are selected. Deselect the additional subject areas that shouldn’t use this customization.
  24. Click Finish.
    You see the new customization step in the customization branch. You can now apply the customization branch to the main branch or edit it to add more steps.