October 29, 2008 at 10:58 am
Hi Can anyone please help me on this :
I have a Cube setup on an environment say DEVELOPMENT.
I do the following steps to promote this CUBE to TEST Env:
1.I archive the CUBE which in turn will give me a CAB file in DEVELOPMENT
2.I take this CAB file and restore it on the TEST Analysis Server.
3.I re-build the cubes on the TEST environment.
will the above steps help to get the cubes up with the relevant data of the TEST envirionment?Or will its till show the DEV data?
October 31, 2008 at 4:48 am
If you have done only what you have said then it will still show the DEV data. You will need to change the connection properties for each data source to point to the TEST servers (and again when you promote to live). I've not found a way of renaming the data source so it will probably still be called the name of the DEV server.
Jez
October 31, 2008 at 2:34 pm
Ok so if i change the connection properties and then rebuild the cube , will it show me the test environment data?I dont have to change the datasource name but yes i do need to change the connection properties.
November 3, 2008 at 1:52 am
Yes but you might want to update or rebuild the dimensions so that they pick up data from the TEST region.
Jez
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply