Hard Code in HANA Modelling

[Former Member]

Hi experts,

   In HANA Modelling is there any way to give a hard coded value??

My requirement is : i need to give "$" symbol in front of the Calculated measure. Screen shot attached.

In this the Value should show along with "$" symbol. can we give hard coded?? or is there any other way??

[michael_eaton3]

Hello

It is possible in a calculated column, but as a measure is typically a numeric datatype, and you require a hard-coded string prefix, here's your issue.

Typically, the consumption layer performs formatting of data values rather than the model.

Michael

[Former Member]

Thanks Michael for ur quick reply...

   as it is not possible this way?? is there any alternative ??

[muthuram_shanmugavel2]

Hi Neeraja,

One way for the solution would be,

1. Create calculated column - CURRENCY_CODE like below.

2. Create calculated measure as per your formula and

Mention semantic type as "Amount with Currency code" and

Select currency type as Column and choose the column CURRENCY_CODE.

3. Hide CURRENCY_CODE Column and check the data preview.

Calculated Measure value will be displayed with '$':

Regards,

Muthuram

[Former Member]

Done the same But its not Happening: Check the snaps:Anything other than this to do??

[sk_kamaruzzaman]

I did the same thing & its working for me.

Thanks Muthuram.

[marcel_scherbinek]

Only difference between Muthuram and your procedure is the view. You are in the analytical tab (as seen due to the _SUM aggregation of the key figure) of the SAP HANA Studio and he displays the currency in the raw data tab...

Which Support Package has your SAP HANA system? SPS11?

[michael_eaton3]

This would give you a suffix, rather than a prefix as you asked for.

You haven't specified the Schema for currency conversion, which should refer to a schema that contains the standard SAP currency tables, which you may or may not have available in your HANA system.

Michael

[muthuram_shanmugavel2]

Hi Neeraja,

You are checking data preview in "Analysis" tab.

Please check the data preview in "Raw Data" tab.

Regards,

Muthuram

[Former Member]

Yes using SPS11

[Former Member]

in which schema we will get the standard currency tables??

[Former Member]

Hi Muthuram,

   we can see the output only in Raw data??? why  it is not reflecting in Anlaysis?? so when we use some reporting tools,, the USD is  not reflecting there...what will be issue???