Managing products and portfolios : Investment analysis : Attributes for retrieving financial model results
  
Attributes for retrieving financial model results
The results from the financial analysis of the model are returned to the attributes in the same module that contains the time grid. If time grid values are edited in the time grid editor, the results retrieved from the financial analysis in the attributes is reset to zero. The values must be saved using the Investment analysis interface to retrieve results from the financial analysis of the model.
The values for NPV, NPV Mean, NPV Standard Deviation, ROI, IRR and Payback Period are not calculated for the read-only attributes in a view.
If the connected attributes in a view cannot be edited, those attributes are not updated when they are saved by using Investment analysis.
Important To return the results, the alias of the time grid is used as a prefix for the alias of each result attributes. For example, if the alias of the time grid attribute was defined as TG, the alias of the result attributes must be TG__Alias Suffix respectively.
To define the attributes for financial result analysis, ensure that you have configured a time grid (see Configuring a time grid for investment analysis). Then, use the following table and follow the instructions in Adding attributes.
Tip The Display as Line Chart option and Flip Matrix Axes option are good choices when configuring the matrix attribute.
 
Result
Attribute type
Alias
Example
NPV Distribution
Matrix
time grid alias__NPV
TG__NPV
NPV Mean
Float
time grid alias__NPVMean
TG__NPVMean
NPV Standard Deviation
Float
time grid alias__NPVStddev
TG__NPVStddev
ROI
Integer
time grid alias__ROI
TG__ROI
IRR
Float
time grid alias__IRR
TG__IRR
Payback Period
Integer
time grid alias__paybackPeriod
TG__paybackPeriod
ROI To Date
Matrix
time grid alias__ROIToDate
TG__ROIToDate
ROI To Go
Matrix
time grid alias__ROIToGo
TG__ROIToGo
Payback Period Distribution
Matrix
time grid alias__paybackPeriodDist
TG__paybackPeriodDist
After you configure the attributes to retrieve the financial results, you can build your financial model. See Starting Investment analysis.
See also
Configuring a time grid for investment analysis
Investment analysis