Cancel
Showing results for 
Search instead for 
Did you mean: 

Structure Manager Expansion

Creator
Creator

Dear All, 

 

Greetings! Is there any preferences or settings available to modify the speed of BOM expansion. Currently 90000 line items of one complete BOM taking 1.5 hours. Any solution team?

 

Regards,


Saravanan

7 REPLIES

Re: Structure Manager Expansion

Pioneer
Pioneer

Try testing with this preference RAC_expand_below_batch_size to different values. By default its set to 1000. What it means is it expand the BOM in a batch size of 1000 lines. Setting it to -1 means the entire BOM gets expanded at one shot. Depending on the size of your workstation and network speed you can increase this value. It usually gives a good result, especially if the client is over WAN.

 

Regards,

RS

Re: Structure Manager Expansion

Creator
Creator

This particular Preference already we have set in place. But still the expansion of BOM taking more than 1.5 hrs over 1 GBPS line.

Re: Structure Manager Expansion

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom
Can you reduce the number of columns before opening this large BOM? Especially, columns for custom properties. The less each line has to show the less time it will take to get through them all.

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Structure Manager Expansion

Pioneer
Pioneer

I do not understand the requiement of the BOM expansion with 90000 line items.

Do we need to export it or print the BOM structure?

Re: Structure Manager Expansion

Creator
Creator

Do we need to export it or print the BOM structure? Both!

Re: Structure Manager Expansion

Creator
Creator
We have only limited Custom properties. To export as Excel or to Print with Proper roll up information, we need to have all the attributes in place.

Re: Structure Manager Expansion

Pioneer
Pioneer

Another option I can think of is to udnerstand if there is anything that can be optimized st the DBA level. You can check with your DBA to check the queries from your session or run AWR reports to see if there are any queries that can be optimized for performance.