We have a query that was created where there are 32 Key Figure structure elements in the columns (some hidden) and
59 characteristic structure elements in the rows (some hidden). From time to time, the query builder needs to make change to the structures. When the user tries to change a structure element (key figure or characteristic), the system just hangs for 2-3 mins before processing. When the user right clicks and chooses edit, it will hang for 2-3 mins. After the change was made and the user clicks ok, it will take another 2-3 mins for the change to process. The problem seems to only be with this query.
Arethere any rules of thumb when it comes to using structures (limits on the amount of elements, etc)? Any suggestions are greatly appreciated.
Gerard Wilson (via Maximina Barry)