Skip to Content

Can two rate models (within the same environment) share the same r_entity and r_account dimensions?

I set up a second rate model to maintain daily exchange rates (the first rate model contains monthly exchange rates) and am using the same R_Entity and R_Account dimensions as in the first rate model. I read somewhere that these dimensions are specific and cannot be shared. Am I required to create another R_Entity and R_Account? My FX restatement isn't running and am wondering if perhaps that is the problem.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

11 Answers

  • Best Answer
    May 04 at 08:16 PM

    Hi Vadim

    Thanks for your help so far. I removed TIMEID on parent members and fixed the October issue so 2017.10 now appears in the dimension rather than 2017.1. Next I will change H1 to have days => months => quarters => years then create H2 with days => weeks => years(based on 52 weeks not 365 days, that's ok) -I'll keep you posted - hopefully the FX restatement package will run sooner or later!

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vadim, sorry but on that answer there is no Accept button. The accept button only appears in one or two spots throughout the thread and there is no logic as to where it appears. The only option i have is to share or alert moderator.

  • May 04 at 04:21 PM
    -1
    Add comment
    10|10000 characters needed characters exceeded

  • May 04 at 04:25 AM

    Sorry, but why do you need a second rate model? Do you have multiple TIME dimensions?

    Please describe all models in your environment.

    Add comment
    10|10000 characters needed characters exceeded

  • May 04 at 11:48 AM

    Yes. The main model uses monthly rates and the new model I am building uses daily rates.

    Add comment
    10|10000 characters needed characters exceeded

  • May 04 at 05:08 PM

    Hope you received the images I sent.

    In the document "How to do Currency Translation for Financial Application using SAP BusinessObjects Planning and Consolidation 7.0 for the SAP NetWeaver Platform.0 for the SAP NetWeaver Platform.0" on page 3 it says:

    • Note: The master data (dimension) can be shared by application within an application set. But for RATE application, to fulfill certain requirements, R_Acct (Account Dimension for RATE application) and R_Entity (Entity Dimension for RATE application) are specific and utilized only by Rate Application.

    It does not say if R_Acct and R_Entity can be shared amongst multiple rate applications.

    Add comment
    10|10000 characters needed characters exceeded

  • May 04 at 06:17 PM

    Apolgogies, it seems the images didn't get uploaded. I will try again.

    Add comment
    10|10000 characters needed characters exceeded

    • P.S.

      "It does not say if R_Acct and R_Entity can be shared amongst multiple rate applications."

      Also it does not say if R_Acct and R_Entity can't be shared amongst multiple rate applications.

  • May 04 at 06:31 PM

    Here they are:

    Add comment
    10|10000 characters needed characters exceeded

    • And you have an error running GM FXTRANS.lgf?

      What error do you have? Post the log!

      By the way, this line is incorrect:

      ENTITY=%ENTITY_GM_SET%

      Has to be:

      OTHER = [ENTITY_GM=%ENTITY_GM_SET%]

      Also check the case for RATEENTITY - is it Global or GLOBAL?

  • May 04 at 06:52 PM

    I did change it to OTHER = [ENTITY.....] and it didn't make a difference but I will change it again now and try again.

    Global is the correct ID.

    Here is the log.

    Add comment
    10|10000 characters needed characters exceeded

  • May 04 at 07:04 PM

    I changed the script to OTHER = [ENTITY_GM=%ENTITY_GM_SET%] and it didn't make a difference. Perhaps the issue is with the TIME dimension, some properties may be incorrectly specified. See images below, I have days => weeks => months => quarters => years. I know this isn't strictly correct in that weeks don't roll into months but that is a separate issue...

    Add comment
    10|10000 characters needed characters exceeded

  • May 04 at 07:17 PM

    Here is a 3rd screenshot. Do I need MONTHNUM or ISBEGINNING properties? Is TIMEID incorrect?

    Add comment
    10|10000 characters needed characters exceeded