How to set currency conversion on restricted column

[former_member184624]

Dear HANA / BW Experts,

As per the existing BW query, they have created restricted keyfigure and enabled the currency conversion.

I am trying to implement same in HANA. I created restricted column. (In HANA, Currency conversion is not possible). So i created calculated column and included restricted column and enabled the currency conversion. While activating, i am getting the error message as "It is not allowed to reference other conversion attribute" . Please guide me, how to solve this issue.

Thanks.

[venkateswaran_k · Accepted solution]

Hi

Did you try this SQL for currency conversion. This returns the rate for me in hana-studio.

You may try with this.

SELECT
	 CONVERT_CURRENCY( "AMOUNT" => 1,
	 "SOURCE_UNIT" => 'SAR',
	 "TARGET_UNIT" => 'USD',
	 "REFERENCE_DATE" => '20200212',
	 "ERROR_HANDLING" => 'set to null',
	 "CLIENT" => '400',
	 "SCHEMA" => 'SAPABAP1',
	 "STEPS" => 'convert' ,
	 "CONFIGURATION_TABLE" => 'TCURV' ) as rate 
FROM dummy;	<br>

[former_member184624 · Accepted solution]

Thank you sharing the code. So i need to apply this code in Restricted column ?

[venkateswaran_k · Accepted solution]

Yes, Please create the calculated col using this code .

Regards,

Venkat