Skip to main content
S
OneStream Employee
SergeyOneStream Employee
OneStream Employee
September 11, 2022
Solved

Where is stored the Currency Name ?

  • September 11, 2022
  • 2 replies
  • 0 views

Hi !

I'm interested to get data from the AuditFXRate table, however this table is not giving the Currency names, but only its ID.

The problem is that, the Currency names are nowhere to be find in the datatable of the application ( it is not in the "Member", "MemberProperty" or "MemberDescription" table). The only plase I can get a reference of these currency is in the "AppProperty" table, where all currency are stored in one row.

Needless to say, the table "FxRate" is not showing the Currency Name as well 🙂

 

--> Where can we find the CurrencyID + CurrencyName information in OneStream ?

 

Regards,

Best answer by TonyToniTone

Currency ID and the corresponding Currency Name are constants within the underlying code and not exposed in any database tables.  If you are interested in having something like this, I would suggest creating an enhancement request to expose the Currency ID with the Currency Name.  The more enhancement requests reported to the Product team, better the chances that the enhancement will be implemented.  In the meantime, here is the ConsId with the Currency Name.   

ConsId = 0 THEN 'AED'
WHEN ConsId = 1 THEN 'AFN'
WHEN ConsId = 2 THEN 'ALL'
WHEN ConsId = 3 THEN 'AMD'
WHEN ConsId = 4 THEN 'ANG'
WHEN ConsId = 5 THEN 'AOA'
WHEN ConsId = 6 THEN 'ARS'
WHEN ConsId = 7 THEN 'ATS'
WHEN ConsId = 8 THEN 'AUD'
WHEN ConsId = 9 THEN 'AWG'
WHEN ConsId = 10 THEN 'AZN'
WHEN ConsId = 11 THEN 'BAM'
WHEN ConsId = 12 THEN 'BBD'
WHEN ConsId = 13 THEN 'BDT'
WHEN ConsId = 14 THEN 'BEF'
WHEN ConsId = 15 THEN 'BGN'
WHEN ConsId = 16 THEN 'BHD'
WHEN ConsId = 17 THEN 'BIF'
WHEN ConsId = 18 THEN 'BMD'
WHEN ConsId = 19 THEN 'BND'
WHEN ConsId = 20 THEN 'BOB'
WHEN ConsId = 21 THEN 'BRL'
WHEN ConsId = 22 THEN 'BSD'
WHEN ConsId = 23 THEN 'BTN'
WHEN ConsId = 24 THEN 'BWP'
WHEN ConsId = 25 THEN 'BYR'
WHEN ConsId = 26 THEN 'BZD'
WHEN ConsId = 27 THEN 'CAD'
WHEN ConsId = 28 THEN 'CC1'
WHEN ConsId = 29 THEN 'CC2'
WHEN ConsId = 30 THEN 'CC3'
WHEN ConsId = 31 THEN 'CC4'
WHEN ConsId = 32 THEN 'CC5'
WHEN ConsId = 33 THEN 'CC6'
WHEN ConsId = 34 THEN 'CC7'
WHEN ConsId = 35 THEN 'CC8'
WHEN ConsId = 36 THEN 'CDF'
WHEN ConsId = 37 THEN 'CHF'
WHEN ConsId = 38 THEN 'CLP'
WHEN ConsId = 39 THEN 'CNY'
WHEN ConsId = 40 THEN 'COP'
WHEN ConsId = 41 THEN 'CRC'
WHEN ConsId = 42 THEN 'CUP'
WHEN ConsId = 43 THEN 'CVE'
WHEN ConsId = 44 THEN 'CYP'
WHEN ConsId = 45 THEN 'CZK'
WHEN ConsId = 46 THEN 'DEM'
WHEN ConsId = 47 THEN 'DJF'
WHEN ConsId = 48 THEN 'DKK'
WHEN ConsId = 49 THEN 'DOP'
WHEN ConsId = 50 THEN 'DZD'
WHEN ConsId = 51 THEN 'ECS'
WHEN ConsId = 52 THEN 'EEK'
WHEN ConsId = 53 THEN 'EGP'
WHEN ConsId = 54 THEN 'ERN'
WHEN ConsId = 55 THEN 'ESP'
WHEN ConsId = 56 THEN 'ETB'
WHEN ConsId = 57 THEN 'EUR'
WHEN ConsId = 58 THEN 'FIM'
WHEN ConsId = 59 THEN 'FJD'
WHEN ConsId = 60 THEN 'FKP'
WHEN ConsId = 61 THEN 'FRF'
WHEN ConsId = 62 THEN 'GBP'
WHEN ConsId = 63 THEN 'GEL'
WHEN ConsId = 64 THEN 'GGP'
WHEN ConsId = 65 THEN 'GHC'
WHEN ConsId = 66 THEN 'GIP'
WHEN ConsId = 67 THEN 'GMD'
WHEN ConsId = 68 THEN 'GNF'
WHEN ConsId = 69 THEN 'GRD'
WHEN ConsId = 70 THEN 'GTQ'
WHEN ConsId = 71 THEN 'GYD'
WHEN ConsId = 72 THEN 'HKD'
WHEN ConsId = 73 THEN 'HNL'
WHEN ConsId = 74 THEN 'HRK'
WHEN ConsId = 75 THEN 'HTG'
WHEN ConsId = 76 THEN 'HUF'
WHEN ConsId = 77 THEN 'IDR'
WHEN ConsId = 78 THEN 'IEP'
WHEN ConsId = 79 THEN 'ILS'
WHEN ConsId = 80 THEN 'IMP'
WHEN ConsId = 81 THEN 'INR'
WHEN ConsId = 82 THEN 'IQD'
WHEN ConsId = 83 THEN 'IRR'
WHEN ConsId = 84 THEN 'ISK'
WHEN ConsId = 85 THEN 'ITL'
WHEN ConsId = 86 THEN 'JEP'
WHEN ConsId = 87 THEN 'JMD'
WHEN ConsId = 88 THEN 'JOD'
WHEN ConsId = 89 THEN 'JPY'
WHEN ConsId = 90 THEN 'KES'
WHEN ConsId = 91 THEN 'KGS'
WHEN ConsId = 92 THEN 'KHR'
WHEN ConsId = 93 THEN 'KMF'
WHEN ConsId = 94 THEN 'KPW'
WHEN ConsId = 95 THEN 'KRW'
WHEN ConsId = 96 THEN 'KWD'
WHEN ConsId = 97 THEN 'KYD'
WHEN ConsId = 98 THEN 'KZT'
WHEN ConsId = 99 THEN 'LAK'
WHEN ConsId = 100 THEN 'LBP'
WHEN ConsId = 101 THEN 'LKR'
WHEN ConsId = 102 THEN 'LRD'
WHEN ConsId = 103 THEN 'LSL'
WHEN ConsId = 104 THEN 'LTL'
WHEN ConsId = 105 THEN 'LUF'
WHEN ConsId = 106 THEN 'LVL'
WHEN ConsId = 107 THEN 'LYD'
WHEN ConsId = 108 THEN 'MAD'
WHEN ConsId = 109 THEN 'MCF'
WHEN ConsId = 110 THEN 'MDL'
WHEN ConsId = 111 THEN 'MGA'
WHEN ConsId = 112 THEN 'MKD'
WHEN ConsId = 113 THEN 'MMK'
WHEN ConsId = 114 THEN 'MNT'
WHEN ConsId = 115 THEN 'MOP'
WHEN ConsId = 116 THEN 'MRO'
WHEN ConsId = 117 THEN 'MTL'
WHEN ConsId = 118 THEN 'MUR'
WHEN ConsId = 119 THEN 'MVR'
WHEN ConsId = 120 THEN 'MWK'
WHEN ConsId = 121 THEN 'MXN'
WHEN ConsId = 122 THEN 'MYR'
WHEN ConsId = 123 THEN 'MZN'
WHEN ConsId = 124 THEN 'NAD'
WHEN ConsId = 125 THEN 'NGN'
WHEN ConsId = 126 THEN 'NIO'
WHEN ConsId = 127 THEN 'NLG'
WHEN ConsId = 128 THEN 'NOK'
WHEN ConsId = 129 THEN 'NPR'
WHEN ConsId = 130 THEN 'NZD'
WHEN ConsId = 131 THEN 'OMR'
WHEN ConsId = 132 THEN 'PAB'
WHEN ConsId = 133 THEN 'PEN'
WHEN ConsId = 134 THEN 'PGK'
WHEN ConsId = 135 THEN 'PHP'
WHEN ConsId = 136 THEN 'PKR'
WHEN ConsId = 137 THEN 'PLN'
WHEN ConsId = 138 THEN 'PTE'
WHEN ConsId = 139 THEN 'PYG'
WHEN ConsId = 140 THEN 'QAR'
WHEN ConsId = 141 THEN 'RON'
WHEN ConsId = 142 THEN 'RSD'
WHEN ConsId = 143 THEN 'RUB'
WHEN ConsId = 144 THEN 'RWF'
WHEN ConsId = 145 THEN 'SAR'
WHEN ConsId = 146 THEN 'SBD'
WHEN ConsId = 147 THEN 'SCR'
WHEN ConsId = 148 THEN 'SDG'
WHEN ConsId = 149 THEN 'SEK'
WHEN ConsId = 150 THEN 'SGD'
WHEN ConsId = 151 THEN 'SHP'
WHEN ConsId = 152 THEN 'SIT'
WHEN ConsId = 153 THEN 'SKK'
WHEN ConsId = 154 THEN 'SLL'
WHEN ConsId = 155 THEN 'SML'
WHEN ConsId = 156 THEN 'SOS'
WHEN ConsId = 157 THEN 'SPL'
WHEN ConsId = 158 THEN 'SRD'
WHEN ConsId = 159 THEN 'STD'
WHEN ConsId = 160 THEN 'SVC'
WHEN ConsId = 161 THEN 'SYP'
WHEN ConsId = 162 THEN 'SZL'
WHEN ConsId = 163 THEN 'THB'
WHEN ConsId = 164 THEN 'TJS'
WHEN ConsId = 165 THEN 'TMM'
WHEN ConsId = 166 THEN 'TND'
WHEN ConsId = 167 THEN 'TOP'
WHEN ConsId = 168 THEN 'TRL'
WHEN ConsId = 169 THEN 'TRY'
WHEN ConsId = 170 THEN 'TTD'
WHEN ConsId = 171 THEN 'TVD'
WHEN ConsId = 172 THEN 'TWD'
WHEN ConsId = 173 THEN 'TZS'
WHEN ConsId = 174 THEN 'UAH'
WHEN ConsId = 175 THEN 'UGX'
WHEN ConsId = 176 THEN 'USD'
WHEN ConsId = 177 THEN 'UYP'
WHEN ConsId = 178 THEN 'UYU'
WHEN ConsId = 179 THEN 'UZS'
WHEN ConsId = 180 THEN 'VAL'
WHEN ConsId = 181 THEN 'VEB'
WHEN ConsId = 182 THEN 'VEF'
WHEN ConsId = 183 THEN 'VND'
WHEN ConsId = 184 THEN 'VUV'
WHEN ConsId = 185 THEN 'WST'
WHEN ConsId = 186 THEN 'XAF'
WHEN ConsId = 187 THEN 'XAG'
WHEN ConsId = 188 THEN 'XAU'
WHEN ConsId = 189 THEN 'XCD'
WHEN ConsId = 190 THEN 'XDR'
WHEN ConsId = 191 THEN 'XOF'
WHEN ConsId = 192 THEN 'XPD'
WHEN ConsId = 193 THEN 'XPF'
WHEN ConsId = 194 THEN 'XPT'
WHEN ConsId = 195 THEN 'YER'
WHEN ConsId = 196 THEN 'ZAR'
WHEN ConsId = 197 THEN 'ZMK'
WHEN ConsId = 198 THEN 'ZWD'
WHEN ConsId = 199 THEN 'UKP'

2 replies

N
NidhiMangtani
Veteran
September 12, 2022

Hello,

Currency setting would be on the entity dimension. Rate type would be on the scenario dimension. Not sure, what you are trying to achieve.

S
OneStream Employee
SergeyOneStream EmployeeAuthor
OneStream Employee
September 12, 2022

Hello Nidhi,

Thank you for your message. I am actually trying to get the audit trail of the FX Rates in a dashboard, from the data stored in the "AuditFXRate" table.

A simple export of this table is showing this :

Sergey_0-1662965159963.png

As you can see, the SourceCurrencyID and DestCurrencyID cannot be used because these are numbers, while I would need their name (i.e. USD, CAD, GBP, EUR ...).

Right now I was able to get their name by looking at the FX Rates itself in the table, but there should be a better & more structured way to get tge currency name ?

Regards,

    T
    TonyToniToneAnswer
    September 12, 2022

    Currency ID and the corresponding Currency Name are constants within the underlying code and not exposed in any database tables.  If you are interested in having something like this, I would suggest creating an enhancement request to expose the Currency ID with the Currency Name.  The more enhancement requests reported to the Product team, better the chances that the enhancement will be implemented.  In the meantime, here is the ConsId with the Currency Name.   

    ConsId = 0 THEN 'AED'
    WHEN ConsId = 1 THEN 'AFN'
    WHEN ConsId = 2 THEN 'ALL'
    WHEN ConsId = 3 THEN 'AMD'
    WHEN ConsId = 4 THEN 'ANG'
    WHEN ConsId = 5 THEN 'AOA'
    WHEN ConsId = 6 THEN 'ARS'
    WHEN ConsId = 7 THEN 'ATS'
    WHEN ConsId = 8 THEN 'AUD'
    WHEN ConsId = 9 THEN 'AWG'
    WHEN ConsId = 10 THEN 'AZN'
    WHEN ConsId = 11 THEN 'BAM'
    WHEN ConsId = 12 THEN 'BBD'
    WHEN ConsId = 13 THEN 'BDT'
    WHEN ConsId = 14 THEN 'BEF'
    WHEN ConsId = 15 THEN 'BGN'
    WHEN ConsId = 16 THEN 'BHD'
    WHEN ConsId = 17 THEN 'BIF'
    WHEN ConsId = 18 THEN 'BMD'
    WHEN ConsId = 19 THEN 'BND'
    WHEN ConsId = 20 THEN 'BOB'
    WHEN ConsId = 21 THEN 'BRL'
    WHEN ConsId = 22 THEN 'BSD'
    WHEN ConsId = 23 THEN 'BTN'
    WHEN ConsId = 24 THEN 'BWP'
    WHEN ConsId = 25 THEN 'BYR'
    WHEN ConsId = 26 THEN 'BZD'
    WHEN ConsId = 27 THEN 'CAD'
    WHEN ConsId = 28 THEN 'CC1'
    WHEN ConsId = 29 THEN 'CC2'
    WHEN ConsId = 30 THEN 'CC3'
    WHEN ConsId = 31 THEN 'CC4'
    WHEN ConsId = 32 THEN 'CC5'
    WHEN ConsId = 33 THEN 'CC6'
    WHEN ConsId = 34 THEN 'CC7'
    WHEN ConsId = 35 THEN 'CC8'
    WHEN ConsId = 36 THEN 'CDF'
    WHEN ConsId = 37 THEN 'CHF'
    WHEN ConsId = 38 THEN 'CLP'
    WHEN ConsId = 39 THEN 'CNY'
    WHEN ConsId = 40 THEN 'COP'
    WHEN ConsId = 41 THEN 'CRC'
    WHEN ConsId = 42 THEN 'CUP'
    WHEN ConsId = 43 THEN 'CVE'
    WHEN ConsId = 44 THEN 'CYP'
    WHEN ConsId = 45 THEN 'CZK'
    WHEN ConsId = 46 THEN 'DEM'
    WHEN ConsId = 47 THEN 'DJF'
    WHEN ConsId = 48 THEN 'DKK'
    WHEN ConsId = 49 THEN 'DOP'
    WHEN ConsId = 50 THEN 'DZD'
    WHEN ConsId = 51 THEN 'ECS'
    WHEN ConsId = 52 THEN 'EEK'
    WHEN ConsId = 53 THEN 'EGP'
    WHEN ConsId = 54 THEN 'ERN'
    WHEN ConsId = 55 THEN 'ESP'
    WHEN ConsId = 56 THEN 'ETB'
    WHEN ConsId = 57 THEN 'EUR'
    WHEN ConsId = 58 THEN 'FIM'
    WHEN ConsId = 59 THEN 'FJD'
    WHEN ConsId = 60 THEN 'FKP'
    WHEN ConsId = 61 THEN 'FRF'
    WHEN ConsId = 62 THEN 'GBP'
    WHEN ConsId = 63 THEN 'GEL'
    WHEN ConsId = 64 THEN 'GGP'
    WHEN ConsId = 65 THEN 'GHC'
    WHEN ConsId = 66 THEN 'GIP'
    WHEN ConsId = 67 THEN 'GMD'
    WHEN ConsId = 68 THEN 'GNF'
    WHEN ConsId = 69 THEN 'GRD'
    WHEN ConsId = 70 THEN 'GTQ'
    WHEN ConsId = 71 THEN 'GYD'
    WHEN ConsId = 72 THEN 'HKD'
    WHEN ConsId = 73 THEN 'HNL'
    WHEN ConsId = 74 THEN 'HRK'
    WHEN ConsId = 75 THEN 'HTG'
    WHEN ConsId = 76 THEN 'HUF'
    WHEN ConsId = 77 THEN 'IDR'
    WHEN ConsId = 78 THEN 'IEP'
    WHEN ConsId = 79 THEN 'ILS'
    WHEN ConsId = 80 THEN 'IMP'
    WHEN ConsId = 81 THEN 'INR'
    WHEN ConsId = 82 THEN 'IQD'
    WHEN ConsId = 83 THEN 'IRR'
    WHEN ConsId = 84 THEN 'ISK'
    WHEN ConsId = 85 THEN 'ITL'
    WHEN ConsId = 86 THEN 'JEP'
    WHEN ConsId = 87 THEN 'JMD'
    WHEN ConsId = 88 THEN 'JOD'
    WHEN ConsId = 89 THEN 'JPY'
    WHEN ConsId = 90 THEN 'KES'
    WHEN ConsId = 91 THEN 'KGS'
    WHEN ConsId = 92 THEN 'KHR'
    WHEN ConsId = 93 THEN 'KMF'
    WHEN ConsId = 94 THEN 'KPW'
    WHEN ConsId = 95 THEN 'KRW'
    WHEN ConsId = 96 THEN 'KWD'
    WHEN ConsId = 97 THEN 'KYD'
    WHEN ConsId = 98 THEN 'KZT'
    WHEN ConsId = 99 THEN 'LAK'
    WHEN ConsId = 100 THEN 'LBP'
    WHEN ConsId = 101 THEN 'LKR'
    WHEN ConsId = 102 THEN 'LRD'
    WHEN ConsId = 103 THEN 'LSL'
    WHEN ConsId = 104 THEN 'LTL'
    WHEN ConsId = 105 THEN 'LUF'
    WHEN ConsId = 106 THEN 'LVL'
    WHEN ConsId = 107 THEN 'LYD'
    WHEN ConsId = 108 THEN 'MAD'
    WHEN ConsId = 109 THEN 'MCF'
    WHEN ConsId = 110 THEN 'MDL'
    WHEN ConsId = 111 THEN 'MGA'
    WHEN ConsId = 112 THEN 'MKD'
    WHEN ConsId = 113 THEN 'MMK'
    WHEN ConsId = 114 THEN 'MNT'
    WHEN ConsId = 115 THEN 'MOP'
    WHEN ConsId = 116 THEN 'MRO'
    WHEN ConsId = 117 THEN 'MTL'
    WHEN ConsId = 118 THEN 'MUR'
    WHEN ConsId = 119 THEN 'MVR'
    WHEN ConsId = 120 THEN 'MWK'
    WHEN ConsId = 121 THEN 'MXN'
    WHEN ConsId = 122 THEN 'MYR'
    WHEN ConsId = 123 THEN 'MZN'
    WHEN ConsId = 124 THEN 'NAD'
    WHEN ConsId = 125 THEN 'NGN'
    WHEN ConsId = 126 THEN 'NIO'
    WHEN ConsId = 127 THEN 'NLG'
    WHEN ConsId = 128 THEN 'NOK'
    WHEN ConsId = 129 THEN 'NPR'
    WHEN ConsId = 130 THEN 'NZD'
    WHEN ConsId = 131 THEN 'OMR'
    WHEN ConsId = 132 THEN 'PAB'
    WHEN ConsId = 133 THEN 'PEN'
    WHEN ConsId = 134 THEN 'PGK'
    WHEN ConsId = 135 THEN 'PHP'
    WHEN ConsId = 136 THEN 'PKR'
    WHEN ConsId = 137 THEN 'PLN'
    WHEN ConsId = 138 THEN 'PTE'
    WHEN ConsId = 139 THEN 'PYG'
    WHEN ConsId = 140 THEN 'QAR'
    WHEN ConsId = 141 THEN 'RON'
    WHEN ConsId = 142 THEN 'RSD'
    WHEN ConsId = 143 THEN 'RUB'
    WHEN ConsId = 144 THEN 'RWF'
    WHEN ConsId = 145 THEN 'SAR'
    WHEN ConsId = 146 THEN 'SBD'
    WHEN ConsId = 147 THEN 'SCR'
    WHEN ConsId = 148 THEN 'SDG'
    WHEN ConsId = 149 THEN 'SEK'
    WHEN ConsId = 150 THEN 'SGD'
    WHEN ConsId = 151 THEN 'SHP'
    WHEN ConsId = 152 THEN 'SIT'
    WHEN ConsId = 153 THEN 'SKK'
    WHEN ConsId = 154 THEN 'SLL'
    WHEN ConsId = 155 THEN 'SML'
    WHEN ConsId = 156 THEN 'SOS'
    WHEN ConsId = 157 THEN 'SPL'
    WHEN ConsId = 158 THEN 'SRD'
    WHEN ConsId = 159 THEN 'STD'
    WHEN ConsId = 160 THEN 'SVC'
    WHEN ConsId = 161 THEN 'SYP'
    WHEN ConsId = 162 THEN 'SZL'
    WHEN ConsId = 163 THEN 'THB'
    WHEN ConsId = 164 THEN 'TJS'
    WHEN ConsId = 165 THEN 'TMM'
    WHEN ConsId = 166 THEN 'TND'
    WHEN ConsId = 167 THEN 'TOP'
    WHEN ConsId = 168 THEN 'TRL'
    WHEN ConsId = 169 THEN 'TRY'
    WHEN ConsId = 170 THEN 'TTD'
    WHEN ConsId = 171 THEN 'TVD'
    WHEN ConsId = 172 THEN 'TWD'
    WHEN ConsId = 173 THEN 'TZS'
    WHEN ConsId = 174 THEN 'UAH'
    WHEN ConsId = 175 THEN 'UGX'
    WHEN ConsId = 176 THEN 'USD'
    WHEN ConsId = 177 THEN 'UYP'
    WHEN ConsId = 178 THEN 'UYU'
    WHEN ConsId = 179 THEN 'UZS'
    WHEN ConsId = 180 THEN 'VAL'
    WHEN ConsId = 181 THEN 'VEB'
    WHEN ConsId = 182 THEN 'VEF'
    WHEN ConsId = 183 THEN 'VND'
    WHEN ConsId = 184 THEN 'VUV'
    WHEN ConsId = 185 THEN 'WST'
    WHEN ConsId = 186 THEN 'XAF'
    WHEN ConsId = 187 THEN 'XAG'
    WHEN ConsId = 188 THEN 'XAU'
    WHEN ConsId = 189 THEN 'XCD'
    WHEN ConsId = 190 THEN 'XDR'
    WHEN ConsId = 191 THEN 'XOF'
    WHEN ConsId = 192 THEN 'XPD'
    WHEN ConsId = 193 THEN 'XPF'
    WHEN ConsId = 194 THEN 'XPT'
    WHEN ConsId = 195 THEN 'YER'
    WHEN ConsId = 196 THEN 'ZAR'
    WHEN ConsId = 197 THEN 'ZMK'
    WHEN ConsId = 198 THEN 'ZWD'
    WHEN ConsId = 199 THEN 'UKP'

      Terms & ConditionsAccessibility statement