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

How to create new Currencies & Rates and assign them to Scopes & Flows

In this blog we will describe how to create new Currencies & Rates, which will allow us to convert the financial statements from the Local Currencies of the Entities to the different reporting currencies and group reporting currencies per specific flow.

Creating and Assigning new Currencies

The first activity is creating a new Currency is to simply input a 3 digits Id and description. The Analytic Application is designed to influence multiple dimension members and properties to ensure zero coding is required when adding a new currency or rate.

create new currency
“Add New Currency” Tab

User has to simply input Currency Id and description, then choose if it should be assigned to a Scope, by selecting from the radio button. If “Yes” was selected from the radio button, the “Assign currency to Scope” Tab will be visible.

By clicking on create, the Analytic Application will create the currency in the required dimensions automatically; no further programming required.

If the user inputs an invalid ID, the system will generate an error message with an explanation of the violation.

Invalid ID

List of all Scopes will be automatically generated at the “Assign currency to Scope” Tab. Once the user selects a Scope the system will show details such as: Scope Id, description, and group currency.

assign currency to scope
“Assign Currency to Scope” Tab

Users can add/remove multiple currencies to a Scope by using the checkbox group “Scope Group Currency”.

Creating and Assigning new Rates

Second activity is creating a new Rate. This also requires entering a 3 digit ID and description. The Analytic Application is designed to influence multiple dimension members and properties to insure zero coding when executing currency conversion with new rates and currencies.

Create new rate
“Add New Rate” Tab

After inputting the ID and description for the Rate, the user chose to assign it to a Flow, by selecting from the radio button. If “Yes” was selected from the radio button, the “Assign Rate to Flow” Tab will be visible.

By clicking on create, the Analytic Application will create the rate in the required dimensions automatically; no further programming required.

If the user inputs an invalid ID, the system will generate an error message with an explanation of the violation.

Invalid ID

List of all Flow will be automatically generated at the “Assign Rate to Flow” Tab. Once the user selects a Flow the system will show details such as: Flow Id, description, current rate.

assign rate to flow
“Assign Rate to Flow” Tab

From the dropdown “New Rate to Assign” user can select the rate and save it to the dimension by clicking button “Apply Rate”. This will update the rate for the selected flow and automatically add other properties in different dimensions to ensure zero code required for running currency translation.

Recent Posts

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

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