06-29-2011 08:26 AM
We have just had a new environment created at work and I have been asked to look at replicating the new environment with production.
The SAS apps we have in both environments are:
SAS DI Studio 3.4
SAS EG 4
SAS MC 9.1
SAS IM Studio 3.4
SAS OLAP Cube Studio 9.1
We have several jobs which refresh the underlying data, jobs which refresh the cubes and obviously the physical cubes themselves.
I was wondering the best way to go about this? I.e exporting the jobs as .spk files and the cubes as .xlm files or is there a easier more reliable way?
Also, in Production under out Foundation repository there is some duplicate cubes. I have tried deleting them - the log frame window appears (but is blank) but the duplicates still exist.
Can anyone shed any light on either of the 2 questions above?
Many thanks in advance