ACCUMULATING DATA

[cube7]

Hi,

I have 2 cubes. The first one Actuals has dimensions: account, branch, time and measures. The second one Balance sheet has dimensions:Account_group, Branch, Time and measures.
I have to transfer the data from Actuals to Balance Sheet. Several accounts are mapped to one account_group, but the mapping is different for different Branches.
I created one more cube with dimensions Account and Branch and picklist with dimension Account_group, so that mapping can be written to that cube.
I tried to create rule in Balance Sheet cube with DB function to Actuals and that new lookup cube but with no success.

How would you transfer data between those two cubes.

Thanks in advance!

[mce]

How many different groupings do you have? If it is completely different for each and every branch, how many branches do you have?

[cube7]

There are 9 branches and some accounts will have the same grouping in all branches but most of them will have different grouping. So we need to have 9 possible groupings.

[David Usherwood]

Now we've uncovered the business context....
If your structures are that different you should build nine different cubes with their own rollups, then feed the common level summaries over to a central cube.
If you are _very_ carefull with the nine different summary dimensions, enforcing exactly one parent for each base line, you can use elpar() to do the feeding.
Alternatively, do it in a relational db, linking the rollup to the company for the GROUP BY.

[mce]

Considering that you do not have many branches and assuming that you will not have new branches every month, here is a solution that would solve your problem.
You need to create a seperate group hierarchy in your accounts dimension for each branch. You can name your consolidation levels as concetenaton of branch code and group code in a systemic way. Then you will be able to write a seperate rule statement in your target cube for each branch. You can use your lookup cube having branch and account dimensions to write feeders in your source cube.
I had a similar requirement and solved this way.

[cube7]

Thanks, I will try this with multiple hierarchies.