New Feature for Currency Conversion in Data Warehouse Cloud
Currency Conversion functionality is quite common in data modelling and reporting tools and hence SAP Data Warehouse Cloud is no different. SAP has been adding new functionalities/improvements in DWC tenets regularly. One of the recent addition is a new functionality/improvements around Currency Conversion. Please follow below detailed steps to check out my exploration of this functionality in DWC:
Step 1: Set-Up & Import
Legends say, great things in DWC begin with Data Builder and same goes for this functionality as well. I login to DWC to open Data Builder and then click on + Icon to initiate the set-up.
Once I click on it, I get options to select from based on your DWC connection set-up:
In my case I have created a connection between our S/4HANA on-prem system and DWC environment. This has been set-up via Connections functionality in DWC using a DP Agent and is a pre-requisite for using S/4HANA Currency tables and data. One can choose either S/4HANA connectors or the ABAP connector for this purpose. Refer to the official document for further details here.
Following Standard Objects is imported and deployed in the pre-selected workspace:
Once I click on Create button , the standard objects import & deployment starts.
Step 2: Replication & Data Loads
Post deployment, I need to replicate the remote tables:
Post table replication, the Data Flows need to be triggered as well. This will load the data from remote tables to local tables in DWC via Data Flows.
I have used a dummy transaction table (Dummy Data V2) to perform the conversion, sample structure as below:
Source table sample structure
Step 3: Creating View & Calculated Column
Next step is I need to create a view via Data Builder and consume the Dummy Data V2 table as a source. Additionally, I have created an Input Parameter to take in Target Currency as a User Input. Next I need to add a formula node and use below button to create a currency conversion column:
Further I need to fill in the details based on currency conversion needs such as Exchange Rate Type, Reference Date, Error Handling etc. New Values are nothing but the standard views that I have imported in previous steps whereas older values are the direct tables available in S/4HANA system.
Finally I need to deploy and check the data in the newly added column Amount in Target Currency:
Entering AUD as Target Currency:
Thanks Thomas Bodenmueller-Dodek for highlighting Business Builder. Currency Conversion functionality can also be leveraged while creating measures in Business Builder -> Analytical Datasets as well.
Pre-requisite is the semantics have to be updated in the Source View to be used, sample as below.
Post semantics, I will go to Measures tab in the Analytical Data set and create Converted Measure configuring as per the conversion needs.
*****End of update**********
In conclusion, this is a great addition by SAP as it helps us in having Exchange rate and other relevant tables selected & replicated from our S/4HANA systems thus saving our time and effort in performing currency conversion using the previously shown preliminary method by Mr. San Tran , refer this blog. Now lets see when we can have similar options for UoM Conversion as well, or am I being greedy. 😛
Thanks for reading the blog, feel free to suggestions/discussions in comments.