BOM Tables Performance
We are having CTO solution for our client. We have around 52 models, 240 orgs, 400 option items. We have loaded Shipment History data for Model and Option Shipments History for options for 2 years. We ran the plan but when our planners are trying to analyze option shipment history & planning percentage by opening BOM tables.
We have enabled CTO_Scaled_Queries profile as well. But the pivot table is not opening fast. We added Organization level in page filter and time level and item level filters were added in members tab. Still it is taking lot of time and most of the time table error out.