Forum Discussion

mizaskun's avatar
mizaskun
Helper II
4 years ago
Solved

Multilingual report maintain filter values translated

Is there any way I can build a multiligual report so that when I filter it by e.g. France country out of France, UK and China, if I change the report language to spanish it maintains the France filter translated to Francia? It should change to Francia out of Francia, UK and China. 

 

I reviewd many different ways to build a multilingual report but could not come up with the way to solve this issue.

 

Any suggestion? 

 

Let's say we have the following fact table:

ID - Country - Product - Amount

1 - FR - 1- 7

2 - FR - 1 - 13

3 - SP - 2 -19

 

The following Country master:

CODE - Langu - Name

FR - S - Francia

SP - S - España

CN - S - China

FR - E - France

SP - E - Spain

CN - E - China

 

And the following Product master

ID - Langu - Name

1 - S - Leche

2 - S - Agua

1 - E - Milk

2 - E - Water

 

Thank you so much in advance!!! 

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Community Support

    Hi mizaskun ,

    For multiple language report, I suggest you refer this community blog which introduces it in details:

    Transform ‘report language’ based on buttons  

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.