How to get the last value from the Information register?

Hi!

I have created the CurrencyRates periodic information register, with Currency dimension and Rate resource. Now I need to get the last record for the specific currency. How can I do this?

Hi, Lies Susann!

You need to use a query like following:

SELECT
   CurrencyRatesSliceLast.Rate
FROM
   InformationRegister.CurrencyRates.SliceLast(&Period, ) AS CurrencyRatesSliceLast
WHERE
   CurrencyRatesSliceLast.Currency = &Currency

Hi Susann. I want to add important remark to Xin Wang answer: use filter by dimension like parameter for SliceLast virtual table.
It is very important for query performance.

SELECT Rates.Rate
FROM InformationRegister.CurrencyRates.SliceLast ( &Period, Currency = &Currency ) as Rates

Thank you, Xin Wang and Dmitry Reshitko!