We are setting up Oracle EPM Planning and Budgeting to better report our financial data. We have 3 BSO environments and 1 ASO environment, though I don't believe the set up has been done as efficiently as possible. Our 3 BSO environments have repeat dimensions rather than being their own unique data set that aggregates into one. For reporting in simple terms we effectively concatenate several dimensions to provide the product line. Internally we proposed creating a new dimension that would be the concatenated data (done in the background via rules) but are now being told that we have used too many dimensions and are going to need to buy another ASO environment to facilitate this.
Currently, our three BSO environments have 14, 13, and 11 dimensions, of which 15 are unique. In other words, 15 dimensions are spread over 3 environments. Our ASO cube has 14 dimensions, all of which are represented in the BSO environemnts. I understand there is data limitation regarding total member count and intersections of blocks, but is there any reason at all we could not create a dimension in BSO, which would be a concatenation (at the end of the process) of our dimensions and push that to ASO? Is there a dimension number limitation?