Hi Michal,

I believe this is posisble using the timezone converter feature.

Have a look at this post, and let us know if this will not do what you're after.
Applying a timezone offset to data returned in a view.

So if you're using the pre-defined date period 'eg. Business week start' it will start the Monday relevant to the user's timzone.

Hope this helps.

Regards,
David

Hi David,
We are using the week number (not pre-defined date period) of sql server. The week number of Sunday depends on the language of the connection.

How can we control the language/country/locale of the data source connection to sql server?

Thanks!

Hi Michal,

The local settings are SQL server dependent. E.g. managed at the SQL server side. You can create custom functions to return the week number.

Here is an example of the 'week' sql server custom function in Yellowfin which takes in a date parameter ($1):

dateadd(datepart(week, $1)

You can modify or add new functions to this file. The file is located at:

Yellowfin/appserver/webapps/ROOT/WEB-INF/custom-functions.xml

http://www.yellowfinbi.com/YFForum-How-to-create-your-own-custom-functions-for-use-in-calculated-fields-?thread=105253

Regards,
Cameron

Hi Cameron,

Thanks for you fast response!
But that wasn't exactly what I meant :(
Is there a possibility to change the "JVM Locale" field (from the 'info web') from 'en_US' to 'UK'? (I think that this may affect the first day of the week and change it from sunday to monday).

Thanks!

Michal.

Hi Michal,

Unfortunately nope, these are system wide settings and not per user or client org. :(

Regards,
David