Localisation
- Add – Application languages have increased with the addition of Arabic, Hebrew, Hindi, Indonesian, Korean, Malaysian, Chinese Mandurian, Combonian and Romanian. Previously the core languages were English, Japanese, Spanish, Portugues, French, German, Italian, Chinese, Finnish and Russian. This bring the total to 20 languages but additional translation can be added to Sharperlight by end users or partners in Client Setup Localization.
- Change – Support for Google Translation API in the Datamodel Dictionary and Studio where automatic dictionary labels can be automatically translated in bulk. API Keys can be created using the Google web site https://cloud.google.com/translate/docs/reference/rest When using Studio, the Google Transaction API Key can be set in Tools/Options/Languages menu.
Reporting Rows
- Add – Additional Filter Criteria parameters have been increased from 3 to 8 Previously there was A, B and C and now this has been increased with the addition of D, E, F, H.
Query Builder
- Add – Expression called StatisticsLinearTrend (DataPoint,ReturnSlope,dataSeriesList) to complement the existing expressions called StatisticsAverage(), StatisticsGrowth() and StatisticsForecast(). StatisticsLinearTrend take a series of values and calculate the running linear Trend or the slope value if the parameter is true. There are three ways the data series can be passed to the function. One is to make a comma delimited list e.g. StatisticsLinearTrend( DataRowCount(), false,”100,200,300,400,500,600″). The second is to use a Sub Query and one of its output names e.g. StatisticsLinearTrend ( DataRowCount(), false,”S153012.Amount”). Lastly one can set the data as parameters up to 32 slots. StatisticsLinearTrend ( DataRowCount(),false ,{%Jan},{%Feb},{%Mar},{%Apr},{%May},{%Jun},{%Jul},{%Aug},{%Sep},{%Oct},{%Nov},{%Dec})