Is there an upper limit on the number of transforms and or connectors that can be brought into a cube before reliability suffers?
I have about 40 data connectors I need to get in a dashboard. Each one only has 2-3 metrics and 2-3 hierarchies. It is getting cumbersome to work with in one cube and even small changes created waterfalling failures in the cube that results in a lot of extra work. I was wondering if it would be better technically to break it up into 5-6 sub cubes and then either union those cubes into a super cube or feed my dashboard from the 6 cubes. Which would be better/faster/more reliable?
Thanks.