Has anyone wrestled with the following issue?
In our organization, we have Dundas project organized by the business unit, i.e. Finance has theirs, Sales has theirs, etc. User groups (and security) are also organized by the business unit. We publish dashboards, metric sets, cubes, etc to the various projects. So far so good.
Now we have power users who are allowed to create metric sets, but not cubes. The catch is that we want power users to be creating metric sets in their personal projects, and not proliferating half-developed metric sets in the production areas.
What’s the best way to make this happen? Currently, when you attempt to build metric sets off existing cubes, it looks like the U/I is forcing choice from the current project only. Dropping the cube in GLOBAL is not attractive either, as many business units a measure of control over how their internal data is distributed.