How to use COPYLC ?

[Former Member]

Hi community,

On my project we use specifics accounts as indicators (like number of days, number of tickets, worked hours...).

Thoses indicators are used to calculate KPI like :

- Number of tickets/number of days = daily attendance.

- Sales/worker hours = Productivity

As those indicators don't represent money, they're loaded in LC currency and not converted (i.e. in Account Dimension the RATETYPE property is empty).

In reporting we can't show revenue accounts (like Gross Sales, Sales, Production...) in LC but in EUR.

The issue is that there's no data on indicators accounts in EUR as they're not converted, looking for a solution on SCN, we find de R_ACCOUNT [COPYLC].

The need is to convert LC to EUR with 1 LC  = 1 EUR.

I tried to set it  with :

- R_ACCOUNT as :

- ACCOUNT Dimension as :

- Business Rule as :

After that I :

- Saved Rule table

- Processed both R_ACCOUNT and ACCOUNT dimension

- Processed the model

- Launch de FX Restatement package

- Refreshed MetaData cache

The result is the same, i.e. datas in LC but not in EUR.

Is anybody knows how to set COPYLC ?

Thank you,

Anthony.

[Former Member]

Hi Anthony,

I have never called the R_ACCOUNT member COPYLC, instead we usually called it NTR (for no translation) or something similar.

The other question is, on the accounts you mention, which flow dimension member do you use?

Also, do you use the Entity FX Type property in any other FX business rule?

BR,

Arnold

[Former Member]

Hi Arnold,

COPYLC as member ID of R_ACCOUNT doesn't matter, it's the formula [COPYLC] linked to the member of R_ACCOUNT ("COPYLC" in my case) that matter.

In the business rule, I use Balance as Flow.

I don't use Entity FX Type property.

Thank you for your help,

Anthony.

[Former Member]

Hi Anthony,

I was just thinking that maybe the ID COPYLC confuses the system as it might be a reserved keyword.

Is all data that you want converted 1:1 on the flow BALANCE or do you have data on other flows?

Other than that, I use NTR as the ID in the R_ACCOUNT dimension but the same business rule configuration and it works fine.

BR,

Arnold

[Former Member]

Hi Arnold,

I didn't think about the confusing ID, it's a lead to follow.

All data to be converted 1:1 are on BALANCE.

Thank you for your Help,

Anthony.

[Former Member]

Hi,

Try by using :

NTR in the R_Account

And

COPYLC in the business formula,

Tks,