analytical_type_(0..x)_codes

This drop contains information about a particular dimension or set of companies. Remember that there can be several analytical types to loop over starting from 0 (i.e. analytical_type_0_codes, analytical_type_1_codes, analytical_type_2_codes, etc.).

These drops and methods can be used to access both analytical (file with dimensions) and consolidation (file with several companies) data.

Methods

MethodReturn typeDescription
codeintegerUnique code that each company/dimension category has. It can be used together with the analytical_code filter as seen in the example below.
referencestringThe name of the company/dimension category.

Example 1

To print the name and code for each category within Dimension 1:

{% for dimension in company.analytical_type_1_codes %}
  {{ dimension.reference }}
  {{ dimension.code }}
{% endfor %}
Output

Shop 1

603

Shop 2

604

Shop 3

605

Example 2

To get the name and value of the accounts for that particular dimension category:

{% for dimension in company.analytical_type_1_codes %}

  {{ dimension.reference }}
  {{ dimension.code }}
  
  {% assign accounts = period.accounts | analytical_code:dimension.code | range:"4" %}
  
  {% for account in accounts %}
    {{ account.link }} = {{ account.value | currency }}
  {% endfor %}

{% endfor %}
Output

Shop 1

603

400001 Sales = -1,000.00

---------------------------------

Shop 2

604

400001 Sales = -2,000.00

---------------------------------

Shop 3

605

400001 Sales = -3,000.00

Example 3

We can use the same logic from Example 2 to get the company names, codes and their respective account values in a consolidation file:

{% for entity in company.analytical_type_1_codes %}

  {{ entity.reference }}
  {{ entity.code }}
  
  {% assign accounts = period.accounts | analytical_code:entity.code | range:"4" %}
  
  {% for account in accounts %}
    {{ account.link }} = {{ account.value | currency }}
  {% endfor %}

{% endfor %}
Output

Company A Ltd.

101

400001 Sales = -500,000.00

---------------------------------

Company B Ltd.

102

400001 Sales = -600,000.00

---------------------------------

Company C Ltd.

103

400001 Sales = -700,000.00