All Objects View page

The All Objects View page is displayed as part of the data import process. Use the All Objects View page to:

View, search, and define objects across all tables that are being imported. For a description of the available options, see Defining objects.
Divide very large datasets into multiple segments, called partitions. For an overview of this process, and the available options, see Partitioning data.

Defining objects

Use the All Objects View page to display all the objects in all the tables that you are importing. If you want to view the objects in a single table, or preview the data in the table, use the Preview page.

You can:  

Search for objects in all the tables.
Sort attributes or metrics. To do so, hover the cursor over the Attributes or Metrics header, then click the arrow icon, and select Sort Ascending or Sort Descending.
Quickly convert an attribute to a metric, or a metric to an attribute, by dragging the object from one column to another.
Quickly convert multiple objects at once. Press the Shift key while selecting the objects, and then drag them while holding down the Shift key.

To define an object, you can hover the cursor over the object, then click the arrow icon, and select one of the following:

To exclude the object when importing your data into Web, select Do Not Import.
To define the object as an attribute, select Convert toAttribute.
To define the object as a metric, select Convert to Metric.
* The Convert to Attribute and Convert to Metric options are not available for data imported from a search.
To assign a geo role or shape key to the data column for easier data integration with map-based widgets or visualizations that require geographic information, select one of the following:
To assign a geo role to the data column, point to Define Geography, then select the geo role to assign, such as City, State, or Latitude. You can define your data in more specific detail by having MicroStrategy automatically generate additional geographic information based on the contents of the data column. For example, if the column is assigned the City data type, you can have MicroStrategy automatically generate separate attributes for country and state information. Select the check box next to each attribute to have automatically generated based on the data column, then click OK. For detailed information about which attributes can be generated for each geo role, see the Creating and Configuring a Project chapter of the Project Design Guide.
To assign a shape key to the data column, point to Define Geography, select Others, then select the shape key you want to assign, such as Countries of the World or States of USA. Click OK.
To define the data column without assigning it a geo role, point to Define Geography, select None, then click OK.
* The Define Geography option is not available for data imported from Hadoop or from a search.
To change the data type of the column, point to Change Data Type, and select the data type to use.
To rename the data column, select Rename. Type a name in the field and press ENTER.

Partitioning data

If you are importing very large datasets into MicroStrategy, you can use the All Objects View to divide the dataset into multiple segments, called partitions. The data in the partitions is processed simultaneously, improving the performance of your dashboards, documents, and reports. If you will create selectors or filters that use a search box, you can improve the performance of the search by creating a search index for the attributes in your dataset.  For steps to create partitions and search indexes, see Improving performance: Partitioning large datasets and creating a search index.

The All Objects View page shows the attributes and metrics for your dataset, and the tables that the objects are based on. The All Objects View page contains the following options:

Search Index: Creates a search index on the selected attribute. A search index improves the performance of selectors and filters that use a search box on the attribute.

Note: Creating search indexes takes up additional memory in your machine.
Partition Attribute: Determines the attribute to use to split the Intelligent Cube.
Number of Partitions: Determines the number of segments to split the dataset into. It is recommended that the number be less than or equal to the number of CPU cores on your Intelligence Server. To find the number of CPU cores on your Intelligence Server, contact your system administrator.

Related topics

Improving performance: Partitioning large datasets and creating a search index
About importing data into MicroStrategy Web