Pyramid Models

Pyramid's Query, Analytics and Calculation engine, PYRANA, uses MDX to query MS OLAP and Tabular models, and SAP BW models. All other databases supported by Pyramid are queried using SQL. This latter category is typically used to create data models in Pyramid from the Model component, although it may also include external models like SAP HANA views.

Pyramid models are opened and queried using Discover Pro.

Open Pyramid SQL Model

To open Pyramid (SQL) Models after launching Discover Pro, work through the panels on the New Discovery page:

  1. Select Explorer (blue arrow above) in the toolbar.

    2. Tip: You could, alternatively, use the Favorites or Recents options if your Model is marked as a favorite or has been used recently.

  2. In the Servers column, find and select the server:
    • Use Search (purple arrow, above) to filter servers by name.
    • Use the Type drop-down (yellow arrow) to filter the server list by type.
    • Use the Sort drop-down (green arrow) to arrange the servers by name, type, or to arrange the list by folder. The folder name is created when the data source is created.

    Note: The filter and sort selections are saved within the session, so any subsequent visual will default to your sort and filter selections.

    Tip: Hover your cursor over the server to see the server name, type, and description as a tooltip.

  3. In the Databases column, select the required database within the given server:
    • Use Search to filter databases by name.
  4. In the Models column, select the data model that you want to query:
    • Click Refresh to refresh the list of data models.
    • Use Search to filter data models by name.
    • Use the buttons to view the data models in a List view, Tile view, or Tree View.
  5. Open the data model.

Adding new Servers and Databases

Depending on your access rights and selected server type, you may be able to use Quick Model to create a new server or database on-the-fly:

  • In the Servers column, click Add New Server (orange arrow above) to create a new server.
  • In the Databases column, click Add New Database (blue arrow) to add a new database to your selected server.
  • Click here for more information about Quick Modeling

Models panel

As with other data sources, data models can be viewed in the Tile view, List view, or Tree view.

Open

Click Open to launch a new discovery for the selected SQL model.

Smart Discover

Click Smart Discover to launch Smart Discover and build a discovery for this model. Smart Discover is an AI-driven tool that helps non-technical users to build analytical content using augmentation engines and heuristics. It offers users the simplest method for building data visualizations in Pyramid through a simple point-and-click wizard.

  • Click here for more information about Smart Discover

Ask a question

Click Ask a question to create a discovery using a natural language prompt.

  • Click here for more information about Accessing NLQ

Auto Discovery

Click Auto Discovery to auto-analyze your data and produce a set of machine-built analyses and visualizations. Auto Discovery is only available in the Tile view.

  • Click here for more information about Auto Discovery

Model Views

As usual, there are three ways to view SQL models when launching a new discovery: Tile view, List view, and Tree view.

Like other models, when a SQL model is selected (not opened, clicked in this view), the Information Panel (to the right of any of the views) displays model metadata, which can be refreshed and offers options to Open the model as described above.

Tile View

The tile view displays the models as tiles featuring buttons allowing you to open the model in Discover Pro, Smart Discover, NLQ, or Auto Discovery.

List View

View the models as a list, with columns displaying the creation date, last modified date, and Pyramid version on which the model was created.

Each column can be sorted and filtered. Hover over the column header to display the sort and filter buttons.

Filter the List View

Toggle the arrows to sort the given column or click the filter icon to filter the column.

Tree View

Display the models in a tree view, which is useful if they are organized into sub-folders.

Model Metadata panel

When a model is selected (but not opened) in any of the previous views, an Information Panel displaying the model's metadata automatically appears on the right as the fourth panel. It displays the model name, location, creation date, and description. From this panel you can:

  • Click the Star icon to add the model to your favorites or remove it from your favorites, depending on its current state.
  • Use the Choose Language drop-down to choose a language to display hierarchies, members, and models in. The language list has been set in the database.
  • Select the Refresh Metadata checkbox to refresh the model.
  • Open the selected model in Discover Pro, Smart Discover, or the NLQ (Ask a question).