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

Systems Check and Referential Integrity Interface

Consolidation Extensions’ 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:

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.

Consolidation Extensions' Systems Check and Referential Integrity Interface

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.

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.

Check Flow Rates consolidation configuration starter kit

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.

  Check Audit Trail Types consolidation configuration starter kit

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.

Check Intercompany/Entity assignment Rules consolidation configuration starter kit

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

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

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.