cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Analytical Need 

Often times, you would have the need to support user across the globe that are digesting data from your dashboards.

At these scenarios, the timestamp that was recorded and stored in the DB could be different for the users based on the current timezone.

Therefore, we will need to adjust the date-time recorded to support the users' needs.

Solution

In this case, we will support our users that are located on GMT +1.

To present each user with his relevant timezone, first, we will need to make some changes to our Date dimension:

- Here is how to create a date dimension.

- Create a custom table that adds hours to the relevant date and changes it to the needed timezone. Make sure to add a GMT column as an attribute to the date.

Community_Admin_0-1634555654677.png

Next, as each date is duplicated on our date dimension, we will need to restrict each user to see only one date in order to avoid many-to-many scenarios.

Go to the 'Data Security' section of the relevant cube and choose the relevant GMT for the user:

Community_Admin_1-1634555654624.png

You can also look to automate the Data Security assignment through a REST API call.

That's it!

Version history
Last update:
‎10-18-2021 04:14 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request