Creating an Analytical View Over a Logical View

You can create a new analytical view based on a logical view of a dataset.

The following steps create an analytical view over an existing logical view.

  1. Click Create Analytical View.
    Creating a New Analytical View
    Creating a New Analytical View
  2. The Create Analytical View window modal opens. Note that by default, it shows the logical view as a foundation for building the new analytical view.

    In the Create Analytical View window modal, complete the following:

    • Under Select a base table/logical view for creating the Analytical View, leave the default: logical view geo.national_geo_lv.

      Note the basic format notation: databaseName.[logicalViewName|tableName].

    • Under Name of new Analytical View, accept the default name, or enter the name of the new analytical view. We used the default, geo.national_geo_lv_av_1.

      Note that the naming convention for analytical views follows this pattern: [logicalViewName|tableName]_av_n, where n is 1, 2, and so on.

    • Under Dimensions and Measures, select the items that are relevant to the queries supported by the new analytical view.

      We used Feature Class, State Alpha, and Record Count in this analytical view.

      Note that Partitions do not appear in the logical view, even though the primary table of this dataset uses partitions.

    • Click Create.
    Create Analytical View Modal Window; creating AV over LV
    Creating an Analytical View Over a Logical View
  3. The new analytical view appears on the list of analytical views for the dataset. Note that the interface tags the base table as logical view, using the LV icon. Additionally, the new view requires an initial refresh.

    New Analytical; creating AV over LV
    New Analytical View Over a Logical View

You can see and manage all analytical views, across all datasets, in the general Analytical Views interface described in Managing Analytical Views.

To refresh the analytical views, see Refreshing Analytical Views.