The Pyramid Content node is used to bring Pyramid Discover reports spreadsheets that you or your colleagues created in Tabulate into your Data Flow as your data source. You can select reports from any model and any folder location, as long as you have access to the folder and the report. In the case of discoveries, it is also important to note that the visualization type used in the report (pie, scatter, and so on) does not matter.
Tip: There are a number of Pyramid options that you can set up as your data source. You can use discoveries (whose configuration is described in this topic), tabulations (that you can add as a datasource following the steps in the Pyramid Content: Tabulate topic), and the local In Memory Database (that you can add as a datasource following the steps in Pyramid In Memory Database).
Connect to Pyramid Discover Reports as a Source
Start by adding the Pyramid node to the canvas and go to its 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 for all selected tables. This node can be connected directly to a target node only.
Example: 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 four reports from the My Content domain in the content tree (green arrow below):
Next, these four 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):
Example: Add Pyramid Reports as Multi-Select Table
In this example, four 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).
