This dialog allows you to specify fields and/or node IDs to which to export attribute information.
The "Attributes" column lists all the attributes in the portfolio.
Use the drop downs in the "Portfolio Table Field" to specify the field in the portfolio table to which to export the attribute expected value. The portfolio table is a table that stores results across the entire portfolio. It is structured like a typical database table and is intended to store scalar values.
The remaining columns are used to specify information related to exporting to group-specific tables. Group-specific tables are structured using the node ID structure (see Overview of using Databases in DPL) and may store non-scalar values.
Use the "Grp Tbls EV Node ID" column to specify a node ID to which to export expected values of attributes. You may repeat a node ID in this column to export multiple values to a single node ID. E.g., if you have attributes for free cash flow over a 20 year time period, you could export expected values of all 20 attributes to a single node ID called "free_cash_flow". The values are exported to the node ID in the order of the attributes. You may export non-consecutive values to the same node ID.
Use the "Grp Tbls %'iles Node ID Prefix" column to specify a node ID prefix to which to export the 10th, 50th and 90th percentiles of attribute distribtions. For each prefix you specify, three node IDs will be created: one for the 10th, one for the 50th and one for the 90th. The actual node IDs will end with "_p10", "_p50", and "_p90", respectively. E.g., if you specified a prefix of "perc_free_cash_flow", the node IDs would be "perc_free_cash_flow_p10", etc. You may repeat a node ID in this column to export multiple attribute percentiles to a single node ID. E.g., if you specified "perc_free_cash_flow as the node ID percentile prefix on the 20 free cash flows attributes mentioned above, you would end up with three node IDs (perc_free_cash_flow_p10, perc_free_cash_flow_p50, perc_free_cash_flow_p90) each with 20 values.
Use the "Grp Tbls Distrib Node ID Prefix" column to specify a node ID prefix to which to export the full attribute distribtion. For each prefix you specify, two node IDs will be created: one for the probabilities of the distribution and one for the values. The actual node IDs will end with "_probs", and "_values". E.g., if you specified a prefix of "dist_npv", the node IDs would be "dist_npv_probs" and "dist_npv_values". You may not repeat node IDs in this column.
Versions: DPL Portfolio
See Also