• Replies 11 replies
  • Subscribers 34 subscribers
  • Views 34120 views
  • Users 0 members are here
Options
Related

How to roll-up cycle times and costs of MBOM in Aras MPP Process Plans?

sachin bijadi
Offline

At the moment, we can add cycle times and setup times to operations, and cycle times to steps. But this information does not display anywhere once entered. That is fine, but at least if there was the ability to roll-up the cycle times of all the operations in the Process plan, taht would be great. Has anybody attempted this on their isntances?

On a similar vein, the phantoms and MBOM only parts consumed have costs associated with them (for ex. I intend to have 'Material' category parts in the MBOM (we use polyureethanes for casting) as the quantity and hence the cost of the material is a process parameter and not an EBOM item. Is there any way to roll-up the 'MBOM cost'? Would appreciate if anybody could point me in the direction of how to set this up

Regards

Sachin

Parents

  • Yep, stepelementrenderer was the right answer! You will notice that there are a lot of similar Methods that render all kind of stuff you see in MPP. As all the various elements have their unique look&feel, my version for the Operations may not work for the other elements the same way. I also would add the cycle_time to the caption, just like you did. 

    I also prefer option 2 for doing the rollup, as we normally need these kind of data in the db for various purposes. 

    We can use a similiar concept that is used for the Files flag in ItemType Manufacturer Part and Document. Take a look at the ItemType Document File. There you can find a Server Method that is called at 4 different events. We can use a modified version of this Method for 4 server events in the mpp_Step ItemType, that makes a SUM of the cycle_time property.

    There are two options:

    1. Trigger a SQL procedure (just like the files flag Method) that makes a SUM of the step cycle_times and writes the value in the operation cycle_time

    SELECT SUM(CYCLE_TIME) AS SUM
    FROM innovator.[ <-- add source itemtype --> ]
    WHERE (SOURCE_ID = ' --- add source_id--- ')

    2. Use AML instead of SQL procdure.You normally just use SQL procedures, when you really have no other options. When we work inside a ProcessPlan, we already have full permission access to Operations and Steps. So it should be possible update the cycle_time with AML.

  • Offline in reply to AngelaIp

    Hi ,

    How to rollup cycle time and setup time of operations and set the value of sum of them to a mpp_ProcessPlan property call as 'duration'.

    Thanks.

Reply Children
  • in reply to venkatsai

    Hi venkatsai,

    have you tried the approach similar to the Files flag already? You can literally copy most of the involved Methods. You mainly have to change the SQL procedure to sum up the timing instead of setting a flag to 1/0.

    I have to say that I right now do not want to encourage people to use MPP in the current state. While the basic concept is fine, MPP contains a few fundamental bugs that affects system performance and correctness of data. Please write an email to Aras support were you support all MPP related issues reported by Angela (they will know). Please also let your direct Aras contacts (sales, product management,...) know, that you are highly interested in using MPP, but it´s urgent that Aras enhances the application to make it production usable.

    Encourage all users interested in MPP to do the same! We all will benefit from a well working application. Aras needs to know that there are people interesting in using MPP. Right now it´s unfortunately not at the roadmap. The current roadmap strategy is still further bloating innovator, instead of making the existing stuff work. 

    Many thanks!

    Angela