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.
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.
Add a description for the journal and click the plus sign to add a row.
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.
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.
Then save the data and notify you with the numbers of records changed.
Switching to the report view, the entries are now saved on the Journals model.
Post the Entries, and the values will be published to the cloud 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,
Finding a 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.
And the journal with all the saved and published records on both the InsightCubes Journals Model and InsightCubes Cloud Consolidation Model reports are open.
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.