Hello community,
I try to manage translation in my report but it's a mess 😕
I've a fact table that contains severals columns to manage translation. Based on the user language that is stored in a user table I would like to use the right column in my fact table.
The user table is used in the RLS and the username is used to filter this table. When I activate the RLS the user table is correctly filtered.
My fact table is like:
| Operation | fr_trans | en_trans | es_trans | gb_trans | user_trans |
| | | | | | |
user_trans is defined as like:
user_trans = IF (MAX('TOP_USER'[PREFERRED_LANGUAGE_CD]) ="FR", OCCASIONS_OPERATIONS[fr_trans], IF (MAX('TOP_USER'[PREFERRED_LANGUAGE_CD]) ="EN", OCCASIONS_OPERATIONS[en_trans], IF (MAX('TOP_USER'[PREFERRED_LANGUAGE_CD]) = "GB", OCCASIONS_OPERATIONS[gb_trans],IF (MAX('TOP_USER'[PREFERRED_LANGUAGE_CD]) = "ES", OCCASIONS_OPERATIONS[es_trans], OCCASIONS_OPERATIONS[fr_trans]))))
There is no direct relation between both table.
When I try to view as an user with PREFERRED_LANGUAGE_CD = "FR" I get results in another language. It's like if the RLS applied is not considered when this column is field.
Any Idea ?
Edit
In the repport pane I've a table with | username | PREFERRED_LANGUAGE_CD | test |
| (the one used for RLS) | FR | PL |
test = MAX(TOP_USER[PREFERRED_LANGUAGE_CD]). test is in the fact table
As I can see the test column do not use the restriction and take all values available before RLS is applied. How can I base the column on RLS result please guys ?
