Forum Discussion

MarcusH's avatar
MarcusH
Contributor III
2 years ago

Accessing XFStrings through Business Rules

Does anyone know if it's possible to access XFStrings through Business Rules? We are adding other languages to our application and we are using XFStrings for Cube Views and Dashboards. We want to pre...
Admin
  • MarcusH's avatar
    MarcusH
    2 years ago

    Hi hiren

    I needed to change your code a little bit but I have got it working. And you only need one Dashboard parameter. I changed the parameter default value from

    XFString(Dummy, Culture=|!Culture!|)

    to 

    XFString(|!XFstr!|, Culture=|!Culture!|)

    Then I changed the Rules to this :

    Dim params As New Dictionary(Of String, String) From {{"Culture", "fr-FR"}, {"XFStr", "str_Currency"}}

Dim ParamDisplayInfo As DashboardParamDisplayInfo = BRApi.Dashboards.Parameters.GetParameterDisplayInfo(si, False, params, "Param_Dummy")
brapi.ErrorLog.LogMessage(si, ParamDisplayInfo.DefaultValueAfterSubstitution)

     Note that there are only 4 params - GUID.empty is removed - and the parameter name does not take the dashboard name. This might be a difference in versions.

    So the Rules pass through the XFString name as well as the Culture code. Works beautifully. Thank you so much for your help.

OS_Pizza's avatar
OS_Pizza
Contributor III

MarcusH 

Why dont you go for Dashboard XFBRString instead of XFString. Below example is to show how you can send some information to XFBR and get value in return by applying any logic.

BRString(brRuleName, GetUserCulture, optionalName1 = var1, optionalName2 = var2)

if (args.FunctionName.XFEqualsIgnoreCase("GetUserCulture"))
 Dim UI As UserInfo = BRApi.Security.Authorization.GetUser(si, si.UserName)
 Dim U_Culture As String = UI.UserPreferences.Culture
 Return U_Culture 
End If

 Can you explain about your requirement through some screenshot as it is not very clear.

MarcusH's avatar
MarcusH
Contributor III
2 years ago

There are checks on the Load and Transform step because Trial Balance and IC data is loaded separately and we want to tell the user in their language what the problem is ie you are loading IC data into the TB workflow. So if my culture is English I will see 'There is a problem...', if it's French I will see 'Il y a un problème...', if it's Greek I will see 'Υπάρχει πρόβλημα...' and so on. We are using XFStrings to hold the Cube View and Dashboard text and caption information in different languages. The Load and Transform error messages are generated by Business Rules and we do not want to put the error messages in the Rules themselves because the foreign language has to be validated. We do not want to give someone access to Rules just so they can check the error messages in their language. It makes sense to use XFStrings which are set up for localization and I want to know if it is possible to read XFString entries through Business Rules. 

Dashboard XFBR String is an element of Business Rules - can they look up XFString items? If so what is the syntax? I suspect the answer is no in which case we will use Transformation Rules to lookup the foreign language text.