Pyramid Reports

You can use Pyramid reports (data discoveries) as a data source via the Pyramid node. You can select reports from any model, folder location (as long as you have access to the folder and report), and regardless of its visualization type.

Connect to Pyramid Reports as a Source

Start by adding the Pyramid node to the canvas and go to it's Properties panel.

From the content tree, find and select the reports that you want to copy to the data flow. These can be in any folder that you have access to, and all visualization types are supported. You can select multiple reports from different folders and domains.

The selected reports will appear in the Tables selection, and may be added as table nodes or as a single multi-table node. The first option generates an individual node for each table; various other nodes can then be connected to the tables to perform data cleansing and manipulations. The second option generates a single 'Tables' node that for all selected tables. This node can be connected directly to a target node only.

with t

ClosedExample. Connect to Pyramid Reports and Add as Tables

In this example, the user added the Pyramid data source node to the data flow and selected 4 reports from the My Content domain in the content tree (green arrow below):

Next, these 4 reports were selected from the Tables window and added to the data flow using the Add Tables function, connecting each table to the data source via an individual table node (green arrow below):

ClosedExample. Add Pyramid Reports as Multi-Select Table

In this example, 4 tables were selected from the content tree and then enabled from the Tables window. These tables were then added to the data flow using the Add as Multi-Select function, connecting the tables to the datasource via a single multi-select tables node (green arrow below). The process was documented in the Description window for later reference (yellow highlight).