SAP BPC : Currency conversion

[former_member778576]

Hi,

I have a strange behavior concerning my currency conversion.

Below my BUDGET rate for 2024 :

This is my script :

*XDIM_MEMBERSET SCENARIO = %SCENARIO_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET RUBRIQUE = %RUBRIQUE_CONV%

*XDIM_MEMBERSET PARTNER = <ALL>

*XDIM_MEMBERSET DATASOURCE2 = %DATASRC%

*XDIM_MEMBERSET TIME = %MOISN_LFM02_1% // Select all months of the year depending of user selection

*XDIM_MEMBERSET SCOPE = %PROFORMA%

*XDIM_MEMBERSET CURRENCY = TECH_CUMUL

*LOOKUP RATE

*DIM R_ACCOUNT = "AVG"

*DIM PFORMA:INPUTCURRENCY = ENTITY.CURRENCY

*DIM R_ENTITY = "Global"

*DIM CATEGORY = %CATEGORYTAUX%

*FOR %TIA%=%MOIS_PFORMA% // select all months of the year 2024 only

*DIM PFORMA:CATEGORY = "BUDGET"

*DIM PFORMA:TIME = %TIA%

*NEXT

*ENDLOOKUP

*WHEN DATASOURCE2

*IS %DATASOURCE2_SET%

*WHEN ENTITY

*IS BAS(TOTAL_ZONE_GEO),BAS(TOT_TECH_RET),BAS(TOTAL_OPE)

*WHEN SCOPE

*IS %PROFORMA%

*REC(EXPRESSION = %VALUE%*LOOKUP(PFORMA),CURRENCY = "EUR")

*ENDWHEN

*ENDWHEN

*ENDWHEN

Description issue :

My Local Currency is only converted with the budget rate of 2024.12 instead of all the months of 2024.

here's an example :

as you can see, my local currency (tech_cumul) is converted with my december rate (0,52133) and not with the corresponding month rate.

My budget rate of 2024 is fixed, whatever the year selected by the user in the prompt package, my local currency should be converted with the rate of 2024.

Thank you for your help.

Kind regards.

[former_member778576 · Accepted solution]

Hi again,

For those who are interested, in order to resolve this issue, you'll be needed to create a property in dimension TIME (in my case) and fill it with the period desired.

kind regards