Linking Data to Freestyle Reports by Assigning Cell Attributes
To create links between the Freestyle Reports and the financial model accounts, highlight a cell or range of cells (individual cell, row, or column) and assign cell attributes. Each cell must be assigned all five available attributes for information to appear:
Columns and rows must intersect before the information displays. For example, if you assign columns for the years 2003, 2004, and 2005, no information appears until you assign a row of accounts below those columns.
To assign cell attributes:
Select a Freestyle Report.
Highlight a cell, row, or column.
Select Edit, and then Assign Cell Attributes.
Under Entity, select a data source:
None—Paste in copied data, or enter data.
Current—Retrieve data from the current financial model
Alias—Link data from another entity or file (.alc). The source file or entity must have an alias. See Using Alias Manager
When linking calculated data through Alias, you can use Analyze to view the analyze trail from the source.
Under Data Object, define the object from the source to display in the cell:
In Account, select an account.
The available accounts are from the source in Entity. You must select an option in Other.
Click Find Accounts to search accounts.
For Debt Scheduler items, in Account, select one of the debt accounts:
New Senior Notes (v2652)
New Senior Subordinated Notes (v2654)
Total Long Term Debt (v2660)
In Other, select elements to display as report titles, column and row headings, default currency and units, or scenario descriptions:
Under Account Attributes, select the account data to display:
Displays input values or forecast assumptions accounts.
Displays output values.
Displays account names.
Displays account notes.
Displays opposite values from the account data.
Under Time, enter the time periods to retrieve:
Interpret relative time references based on
Specify the source financial model for time information: