FAQ

This section provides answers to common questions about the Financial Reporting OLAP database.

How do I add business content?

You can configure additional detail information, such as analytical or finance dimensions in Business Object configuration in Business Modeling.

You can configure additional KPIs in Business Modeling. Many business objects allow custom properties in Business Modeling. However, the system has limitations for custom rules in standard cubes or for adding elements outside Business Modeling.

If you require completely new content, you can add custom dimensions and custom cubes with rules. A custom cube can include a mixture of standard and custom dimensions.

You can add custom cube rules and folders to standard cubes.

How do I add online currency conversion for my data?

You can add currency conversion rules to the GLCMAIN cube as custom rules by using a custom folder. You must use a separate custom cube for exchange rates.

What if our fiscal year does not start in January?

Select the hierarchy that matches your fiscal calendar’s start month and year type and set as a property of your entity or as the Group Calendar.

What does IMPORT_P13_FY_02_PY mean?

Import for Period 13 in a fiscal year starting in February of the previous year.

Why am I not able to change a unit of measure in the C-Suite dashboard ?

The overview uses by default the Total to keep data consistent across all entities. In detailed dashboards, you can change the unit of measure.

What if I do not include a unit of measure in my report?

Data is stored in the N.A. element, and no additional unit of measure details are required.

What if I do not select the XPADSYSTEM element?

If the XPADSYSTEM element is not selected, the system assigns the default element, which is LOCAL.

Can I add or remove elements in the XPADSYSTEM dimension?

The built-in elements are managed by the system and you can not edit them.

What if no group accounts are configured?

Only the local account structure is published.

Are the custom properties included for all accounts?

Custom properties are included for local accounts but not for group accounts.

What does the N.A. element represent in the Business Objects?

It is used for unassigned data.

How do mapped accounts are displayed?

Mapped accounts are displayed as child accounts under the relevant group account in the GROUP_STRUCTURE hierarchy.

Why am I not able to see a specific KPI?

Only KPIs with the Active property set to TRUE are displayed. Verify the KPI's status.

How are group accounts identified?

Group accounts are prefixed with G_ in the mapping structure.

Where can I find the format string or KPI type?

Format strings and KPI types are published as KPI attributes in the structure.

Can I add custom elements to the XPADCFPROCESSLEVEL dimension?

The built-in elements are fixed and you can not extend them.

Are translations required?

No, but they are recommended for multi-language environments.

What if I deactivate a KPI?

You can no longer select a KPI in reports. If the KPI is a calculated metric or assigned to an objective for the C-Suite dashboard, its rules will still be published.

Can I manually edit the published cube rule?

The manual edition is not possible in EPM Administration. However, KPI rules can be modified in Business Modeling.

What if my calculation references another KPI?

All references are automatically converted to the correct format for the GLCMAIN cube.

What if a metric or account is missing from the hierarchy?

Ensure the metric or account is correctly defined and categorized in the source system. Only properly categorized items are published.

How are calculated metrics handled?

All calculated metrics are published under the Calculated Metrics group with a weight of 0.

Is the Unit of Measure dimension defined as a business object?

Currently, Unit of Measure is not defined as a specific business object in Business Modeling.

However, there are plans to define Unit of Measure as a standard business object and to introduce these properties:

  • Is(Financial)AmountType: property (true or false) is used to group unit of measure elements in the Unit of Measure hierarchy and to filter data in reports.
  • HasUniqueCurrency: property (true or false) is used to determine how the element is weighted in the hierarchy.
These properties control how the unit of measure elements behave in hierarchies, reports, aggregations, and data loads.