Is it possible to copy a hierarchy from one database to another? I've found when I try this, I will get a dialog box that says "Coping members...", and then nothing happens. I've sometimes tried copying a hierarchy on a spare PC and let it sit for a couple hours, and there still will be no progress. Is coping hierarchies impossible in an ASO environment? Is there another way to do this other than coping/pasting? Any help would be greatly appreciated. Thank you!
If you want to migrate the outline then that is possible, the copy/paste functionality for members/hierarchies is not available in ASO.
You could try to extract the information from the source database and load it to the target database with a load rule, or get hold of the metadata which loaded the hierarchies to the source database and reuse it.
It does seem possible to copy and paste members and hierarchies from one outline to another in ASO and in fact we do it every now and then. We do it through EAS interface - open both the outlines in Edit mode and copy from one and paste into another.
I also sometimes faced the issue which Auron is facing - it would just hang and not proceed. It generally happened when trying to copy-paste large hierarchies (100,000+ members). I was able to make it work by using local EAS console and not web one. Sometimes i had to even compress the outline.
I think Sunil has the right answer for you. I've found if I'm trying to copy a really large dimension, I have to break it up into pieces. I'll manually create the top members then copy and paste sections at a time to get it to work. Rember, you can only copy like outlines Aso to ASO BSO to BSO.
The other way I like doing it is to use the outline extractor from Applied OLAP (free download) and export the dimension and then import it into the new outline