I was actually trying to set this up as an ongoing report in Report Builder but for some reason it wont let me add additional eVar dimensions after I add the first two. I was hoping workspace would work (so I could schedule it) like Ad Hoc (especially given workspace is replacing Ad Hoc) where I can set it all up in one step and add many break down dimensions and set the number of unique to show and the number of elements to break down.
In this case I would set it up to show 1000 of the primary eVar (there will never be more than that), Breakdown of primary set to 1000, add the 2nd eVar and have it show 1 and breakdown 1. Add the 3rd eVar and show 1 and breakdown 0. Ad hoc will then add the breakdowns to all of the primary and add the breakdown to every breakdown.
Seems like this is something workspace should be able to do, for my analysis its very common to have layers of breakdowns for several primary dimension elements and its tedious and time consuming to have to go in and add them all individually one at a time to each row