This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Why would I want to use a Link account rather than a formula?
Benefits of Link Accounts
- Link accounts are particularly useful to pull data in from modeled and cube accounts when you want to include dimensionality in your data. For example, let’s say you have your revenue data entered in a cube sheet by a Product dimension. If you pulled this revenue data into a GL account through a regular formula, and then ran a report on the GL account, it would not retain the Product dimension and could not be filtered as such. If you link your GL account to the cube account and run a report on a GL account, you can filter by the Product dimension.
- The Link account is global and will apply to all versions, although can have Actuals disabled such that you can have hard-coded values or different formulas in just the Actuals version.
- Another benefit of a Link account might be performance. Referring to a Cube or Modeled account through a formula would require additional calculations. A Link account, on the other hand, would not be an additional calculation point along the way.
Benefits of Formulas
- If you are looking for different versions to hold different formulas/accounts, it would be better to use formulas to pull over the data instead or perhaps set the GL or Custom account as a Data Entry Sheet Type: Cube so that you can add the GL or Custom account directly to a cube for planning and reporting by dimensions.