Discover Lite Workspace

The Discover Lite workspace is a highly simplified experience from the Discover Pro tools yet still offers some powerful and flexible options for reporting and querying of data.

The workspace includes:

  • An overhead ribbon (green box below)
  • A simplified toolbar (orange box below)
  • Simplified drop zones (red box below)
  • Hierarchy, Measure, and Element Trees (blue box below)

Workspace Elements

Discover Lite Ribbon

The Discover Lite ribbon  appears along the top of the canvas, and it changes according to the selected visual type and the query components. The menu displays a few key functions from the Discover module, to assist in analyzing the query. Click here for details about these functions.

Information

Click the 'i' to the right of the ribbon (yellow box, above) to display the server, database, and model path:

Toolbar (Visualization Picker)

Users can change the query's visualization from the visuals toolbar (red highlight below) by selecting a visual category. From the sub-menu, choose the required visual. For more information, see Visualizations.

Drop Zones and Trees

On the right side of the canvas, you'll find the two panels that allow you to build your visual:

  • Trees of Dimensions, Measures, and Elements panels that you want to add to your visual (orange highlight).
  • Drop Zones (green highlight) that you will drop your metadata into from the trees.

Note: To build your query, you must add hierarchies and elements and measures to the drop zones.

Drop Zones

Hierarchies reside within the dimensions; open the required dimension, find the relevant hierarchy, and drag it onto the drop zones. To add only specific elements within a hierarchy, right click on the hierarchy from the Dimensions panel and select View Elements. Select the required elements wither manually, or using the Members Search.

To add values to the query, find the required measures in the Measures panel and add them to the Values drop zone.

You can add existing business logic from the Measures and Elements panel.

Trees

The tree panels show the data models metadata (Dimensions, Measures, and Elements panels) in a tree format. Select the data that you want to include in the query from these trees.

There are three trees:

  • Dimensions: The model's tables (called dimensions); each dimension can be expanded to show the hierarchies within it.
  • Elements: The attributes (called elements) inside of a selected hierarchy.
  • Measures: The quantitative data (measures) in the model.