Apliqo FPM reflects the organizational organisational structure of the business using the Company and up to four additional business segmentssegment dimensions. Let’s break down the key points of the company dimension:
Balancing Entity: The Company serves as the balance balancing entity. A balance balancing entity is where the sum of the Debits debits and Credits credits in the Monthly Trial Balance equals zero. This balance is check checked for each month is when the Monthly Trial Balance is loaded into Apliqo FPM. If the company does not balance the FPM Administrator needs to approve the difference before it loaded into the Trial Balance to the General Ledger.
Local Currency: The company determines the local currency that the Monthly Apliqo FPM performs currency translations for reporting and analysis in a single currency across the group. Each company will have a local currency. The currency code is maintained to the company in the CurrencyISOCode attribute. The Trial Balance is loaded and the company for forecast is planned in. The Local currency can be translated to the Reporting to the LOCAL element in the FIN Currency dimension. The local currency is translated to a reporting currencies by knowing the currency code of the company . The company’s currencies will determine the included currencies used for currency conversionand the monthly exchange rate. Planning is also done in the local currency of the company.
Total FIN Company: All companies should must rollup to the Total FIN Company consolidation. Other totals and sub-total can be added to the company hierarchy as required by FIN Company dimension to meet the reporting requirements of the business.
NA Company: The FIN Company dimension must have the leaf element NA Company. This is used in Apliqo FPM to store data that is not associated with any company.
In summary, the The Company plays a crucial role in Apliqo FPM , ensuring accurate the accuracy of financial reporting and currency conversions.
...
Company: Shows the current structure of the Company dimension. On this tab you can override the default attributes and set the group security for the company.
Automation: Set Sets the properties and the steps to build the FIN Company dimension. The FIN Company dimension can be built from a csv file, a SQL query (ODBC source), another dimension, an attribute , Process of another dimension, using a custom process or from the Definition tab (cube). Each step in the automation can have one of these sources. When building the Company dimension, each Each automation step is executed in order.
Definition: Allows the FPM Module Administrator to define the parent-child relationship between elements in the Company dimension to build the Company hierarchy.
...
In this section we are going to set up FIN Company dimension using the Definition tab. Using a clean install of Apliqo FPM, the minimum setup of the Company dimension is already defined. Click on the Automation tab. Step 0001 is already fill out. Expand the options by clicking on the > to see the automation settings.
...
When this step is executed, the process will look at the Dimension Definition cube at Source Index 0001 to understand the relationship between the elements of the Company dimension. Click on the Definition tab and select Source Index 0001.
...
Building the hierarchy
The Dimension Definition set out in the same manner as the Company subset editor. On the first line, first column is the Total FIN Company. And on the second line, second column the NA FIN Company. Which is a component of the Total FIN Company consolidation. This layout is the Template Type, ByRollup. Which sets the subsequent entries Based on the setting above the data source for the FIN Company dimension is based on ‘Cube’ a.k.a. the Dimension Definition tab. The Dimension Definition has number of pages or Source Indexes. For this automation step Source index 0001 is used. For convivence, we use the same Source Index as the Automation Step. This is not always the case. The Template Type is ‘ByRollup’. The Template Type determines how the parent-child relationship is calculated in the Dimension Definition tab.
...
Building the FIN Company hierarchy
Click on the Definition tab. Select the FIN Company dimension and the 0001 Source Index.
The Template Type determines the layout of the parent-child relationship. The ‘ByRollup’ closely represents how the hierarchy is presented in the subset editor. Starting from the top of the rollup in the Level 1 column. The next level down in the hierarchy is listed in Level 2 columns on a subsequent row. Level 3 of the hierarchy is in the Level 3 column and so on for each level in the hierarchy. Elements that are in the same column are on the same level in hierarchy. Elements in the next column are components of the element that is in the previous column the directly above the element. Empty rows are ignored when building the dimension.
Up to 30 level can be defined. Click on the ▶ button to add a level. Click on the ◀ to delete the last column.
The vType column determines the element type of the element. The vWeight sets the component weight of the element in its consolidation.
In the example above, the first line, first column is the Total FIN Company element. This is a consolidation. On the second line and in the second column the NA FIN Company element appears. This is leaf element because it has the vType of 'N'. NA FIN Company a component of the Total FIN Company consolidation.
Click on the > ▶ (Add Level to Rollup) will add a column to the table. Click on the + (Add Row) to add more rows to the tableinsert rows in the table. The grid will only show you the next 150 rows after the selected Row Index. Change to row index to see the next 150 rows.
...
Attributes
When the automation Source is Cube, the attributes are maintained in the Dimension tab. Each Source Index can have their own attributes. The ‘Code and Description’ and the ‘Description’ attributes are standard attributes for elements can be maintained in the Dimension Definition page. Attributes can be added or moved.
...
used in Apliqo FPM to give elements a business description. The ‘CurrencyISOCode’ attribute is required for the FIN Company dimension to calculate the reporting currencies from the Local currency.
The follow walk-through will show you how attributes can be added in the Definition tab.
...
Notice the Attribute Name is at the top of the attribute column. The [A] indicates the attribute type, then the attribute name appears, followed by the localisation is any localisation was chosen when the attribute was added.
The following walk-through shows you how an attribute can be deleted from the Definition.
...
Adding a step to the Company dimension
Add The following walk-through add the company code 1000 ‘1000’ to the FIN Company dimension.
...
In this walk-through the Template Type is ‘ParentChild’. On each row of the Dimension Definition the parent relationship to the previous column is defined. Each row defines the relationship of elements from the Element to Parent1, and Parent 1 to Parent 2, etc. Up to eight parent-to-parent relationships can be defined on a single row. The element can be a consolidated element.
Manage company security
...
Select Company from the sidebar. Click on the Security button.
...
Click on Update Security after the permissions are set up, select the group, and press Update Security
...
More information
Setup and Maintenance of the Business Segments MaintenanceClient and Group Administration
...