Skip to Content
author's profile photo Former Member
Former Member

[BPC 10] problem with currencies in script logic

Hi,

I am trying to get this little script to work:

*WHEN CURRENCY*IS EUR*REC(FACTOR=1,ACCOUNT=ACCOUNT.OACC)*ENDWHEN

I have tried this with quotation marks around EUR and without, the result is the same. The system does not do anything. EUR is a member of my currency dimension. The script us called from DEFAULT.LGF.

I also tested by replacing the EUR with LC and it works fine.

Do I have to assume that within script logic I can only use local currency values?

Thanks,

Arnold

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Apr 24, 2012 at 04:34 PM

    Hi Arnold,

    default logic start when you send data or if force it in packages and normally the data are loaded with LC, EUR is a reporting or consolidation currency and will created with sprunconversion but you normally doesn't make changes on it.

    Kind regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Roberto Vidotti

      We use CURRENCY as the currency dimension where we have LC and EUR (in the test environment) and a separate GROUP dimension where we have G_NONE (not consolidated) and G_CONS (consolidated).

      In the live environment we have EUR, USD and GBP as currencies of which EUR and USD are used on G_CONS.

      Thanks,

      Arnold

  • Posted on May 02, 2012 at 08:10 AM

    Hi Arnold,

    I see that your script has explicitly specified EUR based on your posts.

    I guess, there might be no records for that dimension combination in EUR until you run the FX conversion. You may try including the FX conversion before this script. Just a thought that FX conversion might have been missed or skipped in between. Or even the FX conversion might have skipped that particular dimension combo while converting.

    Karthik AJ

    Add a comment
    10|10000 characters needed characters exceeded

    • HI Arnold,

      Can you look at your logic log file located at

      ..\Webfolders\APPSET_NAME>APPLICATION_NAME>PRIVATEPUBLICATIONS\USER_NAME>TempFiles

      Do you see EUR correctly appearing in the SQL statement? The SQL statement is just above the line that says:"Time to load Source data"

      Also, do you see where the logic is saying it is scanning/skipping/processing/generating records:

      i.e.

      1 scanned records

      0 skipped records

      1 processed records

      1 records generated

      Maybe posting your logic log file to this message would be useful.

      Thanks,

      John

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2012 at 06:57 AM

    Hi Arnold,

    It's true that if currency is not explicitly scoped the logic runs against LC. However, you can redirect the calculation to different currency member by scoping it.

    Hope this helps,

    Madis

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Madis,

      we run an FX conversion from LC to EUR as the currency conversion and then to G_CONS as part of the consolidation.

      I can manually enter data on EUR/G_NONE which is then correctly treated (i.e. I can see the correct value on EUR/G_CONS) when I run a consolidation (and also left AS_IS when I run an fx conversion).

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.