✆ UAE: +971 58 5616 616, ✆ USA:+14099168409,   ✉ info@insightcubes.com

Configuration Starter Kit

Consolidation Extensions’ Configuration Starter Kit

The configuration of the Consolidation Extension for SAP Analytics Cloud can be conducted using a preconfigured toolkit. The purpose is to simplify the customization of the consolidation engine and ensure zero conflicts along the way. This simplified and rule-based configuration toolkit can cover for 80% of the currency conversion and elimination configurations.

Consolidation extension Configuration Starter kit

The Configuration Toolkit is composed of the following main sections:

1- Currencies and Rates Configuration Interface

Enables the creation of new currencies and rates, with the option of assigning currencies to consolidation scopes as group reporting currencies and assigning rates to movements/flows for detailed conversion. This custom currency translation solution is designed to ensure detailed conversion beyond the native capabilities of SAP Analytics Cloud that only allow Average and Closing.

2- Scope Configuration Interface

A simple interface to allow the creation of any set of consolidation scopes and develop a parent child relationship between these scopes. This facilitates for designing consolidation scopes that are direct and indirect, covering the legal ownership structure, managerial structure or even industry and segment structures.

3- Audit Trail Configuration Interface

One of the most critical configurations entails the behavior of different Audit Trail members. The Audit Trail Configuration is governed by a set of rules, ensuring no conflict arises while assigning rules to audit trail members.

Through this interface, the consultant or consolidation power user is able to dictate the Audit Trail member data source type, whether they are subject to copy opening rules, currency conversion rules, consolidation rules, enabled for journal entries and even if they are staging members for sub-scope’s values in Staging Consolidation Scenarios.

4- Account Configuration Guide

A guided interface that allows consultants and consolidation managers to assign specific elimination rules to a set of accounts. These preconfigured rules will have a specific elimination logic, subsequent audit trail members that will host the value and clearing accounts that display residuals (in some cases).

The toolset for Account configuration entails rule assignment to Balance Sheet intercompany accounts, Profit and Loss Intercompany Accounts, investment Accounts, capital Accounts, retained earnings and NCI, in addition to profit and treatment, dividend paid/received, and equity method/associates accounts.

Once the assignment of the rules is applied to the set of accounts, along with subset of clearing accounts and audit trails, the elimination rules will be applied to those accounts.

5- Systems Check and Referential Integrity Interface

Make sure that your configuration is done without any conflicts by running these packaged rules. Once the administrator clicks on this Check Button in each of the pages, the system will perform detailed checklist of the configuration and highlight any missing configurations, conflicting configurations and will also list the existing ones for revision.

The logic also performs System Architectural checks including referential integrity checks (cross dimension) and properties assignments that would trigger any of the rules; from journals and copy opening to eliminations and currency conversions.

Checks can be conducted per dimension and cross dimension as follows:

5.1 – Check Account rules: An easy way to list the accounts subject to specific Elimination Rules, and/or assigned Audit trail members, and/or assigned clearing account. This interface enables generating a detailed report that explains how each account will behave based on the applied configurations.

5.2 – Check Currencies and Global/Entity specific rate assignments: Enables quick reporting on the list of entities based on the selected currency. Furthermore, the report will list in a grouped manner the entities that are subject to currency conversion using Global Rates, then the entities that are subject to currency conversion using Entity Specific Rates and finally any entity that is subject to entity specific rate conversion but has a missing configuration. Last, in case an entity has an assigned currency that is not found in the currency model, the last section will indicate this violation.

5.3 – Check Flow Rates: Unlike the Standard currency conversion capabilities of SAC, which are limited to AVG and CLO are rates, the solution allows currency conversion based on any set of rates with automated CTA calculation. The interface allows you to check the assigned Rates to the list of Flows.

The first report allows users to filter the flows based on their assigned rates. The second report is automatically generated when the “Check” button is clicked, showing the list of flows without any assigned rate (Opening and CTA shouldn’t have), then a list of flows grouped based on rates, and last, a list of rates assigned to flows but are missing in the rate dimension.

The last section will generate, upon clicking the check button, any issues in the Flow/Rate configuration.

5.4 – Check Audit Trail Types: A straightforward method to list the audit trail members based on the applied set of properties that governs their behavior: Their assigned Data Source Types, whether they are subject to Copy Opening rules, subject to Consolidation, subject to currency Translation and other criteria.

This interface provides a comprehensive report outlining the behavior of each audit trail member according to the applied configurations.

5.5 – Check Intercompany/Entity assignment Rules: another referential integrity check that lists the entities and their assigned intercompany code, while also identifying any missing assignments or wrong assignments.

Recent Posts

account configuration guide for the consolidation extension

Account Configuration Guide

Consolidation Extensions’ Account Configuration Guide The Account Configuration Guide serves as a preconfigured administrative tool designed to guide users with specific roles to effectively manage

Audit Trail Configuration Toolkit for the consolidation extension

Audit Trail Configuration Toolkit

Audit Trail Configuration Toolkit Audit Trail Configuration Toolkit provides a comprehensive set of tools and resources to help developers easily configure the behavior of the

Scope configuration guide for the consolidation extension

Scope Configuration Toolkit

Scope Configuration Toolkit With our Scope Configuration Toolkit, you can take control of your consolidation scopes with confidence and precision. This interface makes it extremely

SAP Analytics Cloud Calendar

SAP Analytics Cloud Calendar Features and API’s Workflow Organization (Calendar) Use the SAP Analytics Cloud calendar to organize your workflows with calendar events: You can

Get in Touch

Learn more and ask us About Our Cloud Consolidation Solution

Share This Post

Share this Page!

Share this with your network.

Want to Know More?

Get In Touch

Something isn’t Clear?

Feel free to contact us, and we will be more than happy to answer all of your questions.