Building Freestyle Reports

To build a Freestyle Report, you create a blank one first.

With blank Freestyle Reports, there are three ways to enter data:

Entering data directly by typing or pasting the data from another source. See Inputting Data.
Creating formulas referencing other cells in the report or other reports. See Creating Formulas in Cells.
Linking accounts by assigning cell attributes.

See Linking Data to Freestyle Reports by Assigning Cell Attributes.

Note:

When creating freestyle reports in Strategic Modeling, group the cells together with like attributes; for example, if the entire sheet reports on a particular scenario, select the whole sheet and apply that scenario using the Assign Cell Attributes dialog. If a whole column reports on one specific time period (or other attributes like account label), select the column and assign the desired attribute using the Assign Cell Attributes dialog. You can assign attributes to the sheet, rows, columns, ranges, or single cells. The more attributes are mass-assigned, the fewer instructions are needed to be read when refreshing the sheet, increasing the performance.

Creating Blank Freestyle Reports

There are two ways to create an empty Freestyle Report.

To create Freestyle Reports:

From the Report grouping label, click Insert, and then Sheet.

New freestyle report – a blank worksheet is displayed.
From the Freestyle report, click Assign Cell Attributes. See Linking Data to Freestyle Reports by Assigning Cell Attributes

Inputting Data

To input data into a Freestyle Report, click a cell and enter a value. To paste data from another source, highlight the cell or range of cells in the report, select Edit, and then Paste.

Creating Formulas in Cells

You create formulas in cells. Formulas are stored until deleted from cells. To reference cells in calculations, click a cell following a mathematical operator (for example, +).