Aggregated data to traget cube
SummaryAggregated data to traget cube
I have a requirement to push aggregated data from from one BSO cube to another BSO cube. I am thinking of creating alternate hierarchy in the source cube and export to target cube. Is there any other better way we can accomplish the above requirement?
for example 3 soruce accounts will be aggregated to 1 account and 2 source accounts will be aggregated to 1 accounts and goes on.There are no shared accounts.
Any suggestions will be greatly appreciable.