✆+971 58 5616 616  ✉  info@insightcubes.com

InsightCubes Logo

InsightCubes Cloud Consolidation – Journals

Using the Journals dashboard with SAP Analytics Designer.

The journal interface in SAP Analytics Cloud was built using SAP Analytics Designer, allowing entry of adjustments for specific audit trail (type – manual) to impact the standalone or consolidated balances.

Typically, after the Consolidation process has been executed, if specific Eliminations or reclassification is required, a journal entry is done to record such adjustment. However, journals can be used for any kind of adjustment, as long as the end user is aware of the inherit impact of the entry type.

Each journal has a unique ID, making it easily retrievable and identifiable. A Journal can have multiple debit and credit entries, for a specific combinations of accounts, entities, flows and partner companies (InterCo), influenced by the journal context. These entries can be parked (saved) and posted (written to database), unposted and deleted.

Journals Dashboard

To create a new Journal in the SAP Journals dashboard, first click Create New Journal, and select all the intersections you want to save the data records on from the dimensions dropdowns; version, currency, scope, audit, and date.

Select Currency from dropdown of the journal context
Enter date in the input field of the journal context
Select Scope from dropdown of the journal context
Select form the list of allowed Audit members for manual adjustment

Add a description for the journal and click the plus sign to add a row.

Enter a Journal description

Fill in the cells either through selecting the members from the dimensions popups, or manually if you know the member ID, and enter the values to the debit/credit columns.

Member selector popup
Journal entries filled

When done entering all records, save the entries, switch over from the edit to the report view; the records are saved to the Journals model.

The analytics application will check all the selections and apply the filters.

Checking selections and applying filters

Then save the data and notify you with the numbers of records changed.

Entries saved

Switching to the report view, the entries are now saved on the Journals model.

Entries saved on Journals model

Post the Entries, and the values will be published to the cloud consolidation model

Entries published in the consolidation model

The journal is successfully published to two models, the Journal model, and Cloud Consolidation model; result reflected from the report view of the Journals Analytics Application on SAP Analytics Designer,

Journal entries published to two models

Finding a Journal

Find existing Journal

To open a previously created journal, click on the Find Journal button, a popup with all the available journals will appear, chose the desired journal and click View Select Journal.

Select the needed journal

And the journal with all the saved and published records on both the InsightCubes Journals Model and InsightCubes Cloud Consolidation Model reports are open.

Selected Journal opened

Un-post & Delete Journal

To un-post and delete a journal, first click the Unpost Journal; which will revert all the records on the Cloud Consolidation model, then the Delete Journal button; will delete all the records linked to this journal on the Journals model.

Unposting and Deleting a Journal

Recent Posts

Get in Touch

Learn more and ask us About Our Cloud Consolidation Solution

Share This Post

Share this Blog!

Share this with your network.

Want to Know More?

Get In Touch

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