This content has been marked as final. Show 4 replies
Have a read of the studio manual - http://download.oracle.com/docs/cd/E17236_01/epm.1112/est_user.pdf - section - "Placing Actual Members Before Shared Members"
Also Have a look at setting the dimension to multiple hierarchies enabled - Convert BSO to ASO
Thanks for the quick response.
I have gone through the document and now deployed successfully.
But the total figure was not matching with the totals which i have loaded through EIS.
Can you please let me know how to add alias manually, which is not available in table.
In EIS i used to write alias name and add as alias then it will be added.
Edited by: prathap_k on May 19, 2011 3:26 PM
The first error you are seeing is becase you are loading to an ASO cube and by default, dimensions are created as stored hierarchies. You need to change them to dynamic or your design to have multiple hierarchies enabled.
For the second go into the metadata members and there is a second tab for Aliases, you should be able to add the alias there, I don't remember off-hand, but I think text has to be enclosed in double quotes