Discover Pro features a highly customizable workspace, along with a number of panels that are central to the query-building process. Review this section to learn how to navigate the various ribbons, workspaces, and panels that are essential to authoring content in Discover Pro.
Discover Pro Ribbons
Discover Pro features four ribbons, exposing a variety of functionality.
- Report Ribbon: offers quick access to a range of commonly used tools, including a handful of query and formatting functions.
- Design Ribbon: exposes functionality that enables the user to customize the report design.
- Component Ribbon: offers formatting choices that affect the look and feel of the current visualization.
- Query Ribbon: offers a range of tools aimed at customizing the query itself.
Click here to learn about the Discover Pro ribbons.
Discover Pro allows users to choose from a range of workspace presets, and is also highly customizable, enabling users to change the workspace layout using simple drag and drop functionality.
Click here to learn about the Discover Pro workspaces.
Discover Pro Panels
Discover Pro features a number of panels that are central to the report-building experience.
The Drop Zones panel is where the user builds queries; items from the trees (see below) are added to the drop zones and then drive the data that is returned, as well as the visual elements of the query. For example, a user can have a visualization's color driven by a specified measure, simply by adding that measure to the Color drop zone.
The Dimensions, Measures, and Elements Trees expose the tables, columns, and measures in the data model. The user can browse these trees to locate the required items they want to add to the drop zones in order to build the query.
The Dimensions Tree exposes the data model's dimensions (equivalent to the tables in the data source). Each dimension can be expanded, revealing the hierarchies (equivalent to columns in the data source) contain within it. The required hierarchies are then added to the drop zones.
The Elements Tree is comprised of the elements (equivalent to a column's rows in the data source) within a given hierarchy. The user can open a hierarchy's elements tree and add only specified elements to the query, rather than adding the entire hierarchy.
The Measures Tree contains the model measures, divided into subfolders. The user locates the required measure within its folder and then adds it to the drop zones.
The Metadata Refresh function is used to refresh the model metadata in the dimensions, elements, and measures trees, to ensure they are up-to-date.
When working with MS OLAP, Tabular, SAP HANA, and SAP BW data models, users can change the language for the trees from Discover.
Pyramid's Visualizations Engine offers dozens of data visualizations, including custom visualizations. Users can select a visualization from a new canvas, from the visualization menu, or from the Report Ribbon.
Click here to learn about how to select and change the visualization.
Navigate the Content Panel to locate existing data discoveries and open then in a new tab.
The Metadata Panel provides context by detailing the report metadata, including the data model being queried, and the database and server to which it belongs, and statistics showing the number of columns, rows, and cells in the query.
The Performance Dialog exposes information about the time taken for the query to run, and the size of the query.