Export and Import in Data warehouse
Hi,
I have built a data warehouse project with few dimensions and a cube on a server machine, say server1. Now i have another server machine on which i want to develop this project for bulk production.
I want to import all the developments from server1 to new server machine, say server2, To save my time. I exported data from server1 using export functionality and imported the same file to server2 using import function. My questions is.......
Is it possible to use all the imported objects like cube, dimension, mappings, tables and sequences in the same way in server2 as i was using in server1. If yes then what are the necessary configurations, i have to made.???? because imported dimensions are not able to deploy in new server2 machine giving different errors especially invalid location and invalid table errors for mapping and dimensions.
thanks in advance
imran