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

BPC Package Values Trebling

Hi,

We have a strange issue with a couple of our custom data packages. The issue is that the values which are being copied are being multiplied by 3 each time we run it.

The package is simply moving the data from one application to another, changing the names of the certain members so that it can be recognised in the destination cube. Here is the code logic we are using:

*WHEN ACCVOLUME.MOVE_TO_LABOUR
*IS Y
*REC(FACTOR=1)
*IS Z
*REC(FACTOR=1,ACCVOLUME="VOLPROD")

*ENDWHEN

*DESTINATION_APP=LABOUR
*ADD_DIM MACHINE=NOMACHINE
*RENAME_DIM ACCVOLUME=ACCLABOUR
*SKIP_DIM=MARKET
*SKIP_DIM=RPTCURRENCY
*ADD_DIM WIP=NOWIP
*ADD_DIM LINE=NOLINE

*Commit

Please let me know if you need any more information from me on this issue.

Thanks,

Jamie

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 31, 2012 at 11:02 AM

    Hi guys

    Sorry I've not posted on this thread for a while. So, just to update you on my issue, I've checked all three fact partitiion tables (tblFAC2, tblFact & FACTWB) and could not find any records where Source <> 0. I also restarted the sendgovernor service while no one was using the system and tried running the data package again. Unfortunately the data is still being doubled as if the package were running twice through.

    Have I done everything correctly and is there anything else anyone can suggest I try?

    Thanks,

    Jamie

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 18, 2012 at 09:22 AM

    Hi Jamie,

    Does the issue persist if you restart the sendgovernor service?

    Thanks, Safa

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2012 at 10:32 AM

    Hello Jamie,

    Please try the below code -

    *DESTINATION_APP=LABOUR

    *ADD_DIM MACHINE=NOMACHINE

    *RENAME_DIM ACCVOLUME=ACCLABOUR

    *SKIP_DIM=MARKET

    *SKIP_DIM=RPTCURRENCY

    *ADD_DIM WIP=NOWIP

    *ADD_DIM LINE=NOLINE

    *WHEN ACCVOLUME.MOVE_TO_LABOUR
    *IS Y
    *REC(FACTOR=1)
    *IS Z
    *REC(FACTOR=1,ACCVOLUME="VOLPROD")

    *ENDWHEN

    *Commit

    Ensure that you have *Commit only once.

    Also, have you restricted the scope using XDIM_MEMBERSET?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2012 at 07:28 PM

    Hai,

    the best practice in moving data from one application to another application is Clearing the destination application first.

    the second is the you are caliculating then you are posting the data in another application use the caliculation part below destination app

    like this

    *DESTINATION_APP=LABOUR

    *ADD_DIM MACHINE=NOMACHINE

    *RENAME_DIM ACCVOLUME=ACCLABOUR

    *SKIP_DIM=MARKET

    *SKIP_DIM=RPTCURRENCY

    *ADD_DIM WIP=NOWIP

    *ADD_DIM LINE=NOLINE

    *WHEN ACCVOLUME.MOVE_TO_LABOUR
    *IS Y
    *REC(FACTOR=1)
    *IS Z
    *REC(FACTOR=1,ACCVOLUME="VOLPROD")

    *ENDWHEN

    *commit

    the reason you are getting triple value is first you have value in destination app+first caliculated value+second caliculated value

    thanks,

    Rajesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 21, 2012 at 07:21 AM

    Hi Jamie,

    Please check if the issue persists only for the particular packages or does it occur even when sending data from BPC excel. If issues persists regardless of the package or interface, then the issue is related application/appset/server, not in script logic. Probably, fac2 might not have been processed.

    If it occurs only in particular packages, check whether you have skipped any necessary dimension. Run a clear logic in the destination application before running this DESTINATION_APP script. If the problem still persists, then it lies some other part of the logic. Either you have missed filtering the records by XDIM_MEMBERSET or some other default logic is running in the destination app or some other part of the logic does this.

    Karthik AJ

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Jamie,

      You have mentioned that the issue occurs even through Excel. This means the issue is not in script logic. Your fac2/wb partition table has not been processed properly. Check for records with Source<>0 in all three fact partition tables.

      One of the Optimization process has failed. Check your Data Manager logs to trace out from when this had occurred. Check what strange thing had occurred just before the error in the server.

      For resolving this, take the system offline and make sure no data is posted in between. Delete all the records with source<>0 and restart the send governor service.

      Find out the problem that caused the fac2 partition process failure and resolve it.

      Bring the system back online and repost the data if needed.

      Karthik AJ

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.