You can set given tables and columns for the specific purpose of security and/ or distribution. Security tables and columns appear only in the dynamic member security panel in the Admin console. Distribution tables and columns are visible only when configuring data mapping distribution for publications. Aggregated tables are not visible to users of the model, but are used automatically by Pyramid's query engine to speed up certain types of query.
Security Tables and Columns
- Click here to learn more about security tables and columns.
Distribution Tables and Columns
Distribution tables and columns will not appear in the data model; users will not be able to use them to build queries or other logic. The distribution tables or columns will only be exposed to users when configuring dynamic data mapping distribution of publications; they will be able to use the distribution tables or columns to write a PQL expression, and dynamically distribute the publication based on that expression.
- Click here to learn more about distribution tables and columns.
Aggregate Tables are special tables in your model that contain Measures that have been aggregated by a selected Attribute or Attributes. Pre-aggregating Measures can speed up certain queries at run time, especially where there is a large table of individual records to aggregate (perhaps many millions).
Aggregated tables are not visible to users of the Model, for example in Discover. They are used automatically where relevant by the Pyramid query engine.
- Click here to learn about aggregate tables.
Custom Query Tables
When directly querying an SQL data source, you write SQL scripts to produce custom tables. This is a good alternative to the functionality offered by the Query node in the Data Flow, which is not supported by direct querying.
- Click here to learn about custom query tables.