Selecting Working Language text for Data Source

[Former Member]

Hi FC Experts,

I would like to translate the Data source member values to my working language but cannot find where the values are stored.

We are using the English Application Language and using the Japanese working language to substitute our local language translated members.

For master data members and for dimension names e.g. Category, Reporting Unit I translated successfully. I cannot find the Data source member. It’s not under the Reference tables.

Please see the attached.

Any ideas?

We are using FC 10.1 SP05.

Thanks in advance

Eyal

datasourcelanguage.png

[Olga_Vasileva]

Hello Eyal Feiler,

These descriptions can be updated by FC SQL rule or by SQL query straight in database: in table ct_datasource elements for 'Package data', 'Preconsolidation data' and 'Consolidation data' have name PKAMOUNT, PCAMOUNT and COAMOUNT respectively, and to change Local language description you generally need to change their sdesc6 and ldesc6.
Here is an SQL example for Russian language for datasource FC_SK and database dbo (you will need to change those for your SQL query, or skip entirely in a FC SQL rule leaving just table name ct_datasource without brackets):

update [FC_SK].[dbo].[ct_datasource] set ldesc6 = N'Пакетные данные' where name='PKAMOUNT';

update [FC_SK].[dbo].[ct_datasource] set ldesc6 = N'Преконсолидационные данные' where name='PCAMOUNT';

update [FC_SK].[dbo].[ct_datasource] set ldesc6 = N'Консолидационные данные' where name='COAMOUNT';

If you going to update those descriptions by SQL query in the database, don't forget to stop data source beforehand.

And if you will write a FC SQL rule to update them, start data source in exclusive mode beforehand.

Hope it helps.