I am trying to create a cube that is identical in structure <b><i>and content</i></b> of another cube.
I have created the appropriate objects, i.e. update rule, infopackage etc to copy the contents of the original cube to the copy cube.
After running the copy, even though all statuses were green,I found that there were less rows in the fact table and several dimension tables in the copied cube than there were in the source cube. The sum of all key figures in both cubes match identically (except key figures representing counts of records).
The update rule is pretty straightforward; all key figures and characterstics are moved 1 to 1.
It appears the reason there are less rows in the fact tables is because somehow that some of the rows in the dimension tables were combined into 1.
How can something like this happen (and more importantly be prevented)? I would really like a cube that is a faithful copy of the source cube.
Is there a better way to copy a cube (and it's contents)?