Multilanguage and caching

  • Hi,

    We want to create multilanguage reports that dynamically select the right language depending on the users browser settings.

    For this we used expressions like the following one:

    =Iif (user!Language.StartsWith("nl"),"Lidnummer","Matricule")

    We use the same technique to pass a language parameter to stored procedures that load dropdown listboxes and populate data sets.

    However, the big disadvantage with it is that the caching on the server side doesn't occur anymore. It says there is a user dependence.

    Has anybody a more intelligent way to handle multilanguage?

    thanks,

    Jan

  • Do you want the labels of the reports to be multi-lingual and/or the data?

    gsc_dba

  • The labels AND the data.

    Jan

  • CriticalRationalist (7/7/2010)


    The labels AND the data.

    Jan

    If you have a DW environment you may be able to utilize the "Translations" tab (in Visual Studio for Analysis Service Database), I say may because I havent used this method.

    URL: http://technet.microsoft.com/en-us/library/ms173709.aspx

    gsc_dba

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply