In this section we are going to set up FIN Company dimension.
Menu: Apliqo Settings / Business Segments / FIN Company.
Select Automation on the sidebar.
In the first step is the cube setup for the default elements in the FIN Company dimension.
...
The source of the dimension is CUBE. This means the dimension is build from the Definition page. Note the Source Index is 0001. This is the index in the Dimension Definition page that the dimension definition has been entered.
...
The Template Type is ByParentChild. This mean each line in the Dimension Definition page the element and parent relationship is set.
A number of attributes have been defined for the first step. The Automation page list the attributes type and Alias pattern.
Add a step to the Automation page.
...
Add attritutes to the FIN Company.
In Apliqo FPM the “Description” and “Code and Description” are standard attributes for all dimensions. The FIN Company also needs the “CurrencyISOCode” attribute.
Each Automation Step define their own attributes. The attributes do not have to in the same order as other Automation Steps. Apliqo FPM reflects the organisational structure of the business using the Company and up to four additional business segment dimensions. Let’s break down the key points of the company dimension:
Balancing Entity: The Company serves as the balancing entity. A balancing entity is where the sum of the debits and credits in the Monthly Trial Balance equals zero. This balance is checked for each month is when the 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: 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 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 and the monthly exchange rate. Planning is also done in the local currency of the company.
Total FIN Company: All companies must rollup to the Total FIN Company consolidation. Other totals and sub-total can be added to the 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.
The Company plays a crucial role in Apliqo FPM ensuring the accuracy of financial reporting and currency conversions.
Managing the Company Dimension
You can access the Company setup through the page: Administration > Business Segments > FIN Company. The Company setup page is divided into three tabs.
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: 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 of another dimension, using a custom process or from the Definition tab (cube). Each step in the automation can have one of these sources. 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.
Definition Tab
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.
...
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. 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 insert 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 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
The following walk-through add the company ‘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.
Auto Create Groups
Auto-create Groups button will activate security for the dimension for the first time.
...
Manual Create Group
Security groups can be manually created.
...
Modify the Security
To modify the dimension security, is needed to select a subset and a group.
Permission Level - set the permission level: None, Read, Write, Lock, Reserve, Admin.
Permission Type
Recursive: Apply the same permission level to all children of that element (if the elements do not have any permission set).
Point: Apply permission only to the specific element.
Click on Update Security after the permissions are set up, select the group, and press Update Security
...
More information
Business Segments MaintenanceClient and Group Administration