Performance issue of currency conversion in HANA calculation view

[Former Member]

Hi All,

I've created two graphic view to realize currency conversion.

The lower layer view contains some logic of getting data from source table and processing some join and union process. This view will provide about 100 rows aggregated data (7,000 rows before aggregation) and  the execution time of this view is about 200 ms.

Then I created a upper layer view to do the currency conversion based on the data provided by the lower layer view. But the execution time of currency conversion for these rows is about 2 s, which is quite a long time.

Please suggest me on this problem.

Thanks in advance.

Edward

[former_member182302]

Hi Edward,

Can you share the screenshot of your model and also the let us know more about the currency conversion settings you are doing is it based on the input parameter? Can you share the screens as well?

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

Thank you for your reply.

This is the screen shot of lower layer graphic view model, the whole process consumes 200 ms.

And this is screen shot of upper layer graphic view model, it only contains the process of currency conversion:

Following is the setting of currency conversion in this view on calculated column ''TargetAmount".

Best Regards,

Edward