How to obtain FxRateId in BR.

Question

I am trying to write a query to the FxRates application table however, I cannot find a function to obtain the FxRateId as seen below. I see that the ID changes based on the year and not just the rate type.

Russell · Answer

Can't you just join the 2 tables? FXRate and FXRateType?

SELECT 
    rt.UniqueID              AS FXRateID,           -- the GUID for the rate
    rt.Name                 AS RateTypeName,
    rt.Description          AS RateTypeDescription,
    r.TimeID,
    r.SourceCurrencyID,
    r.DestCurrencyID,
    r.Amount
FROM FXRate r
INNER JOIN FXRateType rt
    ON r.FXRateTypeID = rt.UniqueID

Sign up

Login with SSO

Login to the OneStream Community

Login with SSO