Hi all!
I'm fairly new to Analysis Services and i'm trying to troubleshoot a problem
I'm having with replicating a database on one server. Basically I have a
server that is all good in production. I want to replicate that to a test
server to test out different things. What I've done is backed up the
database in production and restored it on my test server. I then archived
the cube db and restored it on the test server. All the numbers are exactly
the same which is a good thing and expected. However if I do a full process
of the dimensions and the cubes then these numbers become skewed from the
production numbers even though I haven't added any data to the databases.
I'm thinking maybe there is something in the cube strucure that is off from
production, even though I did a straight restore from an archive. There are
about 10 cubes. I wanted to compare every detail from production to test
but that would take a VERY long time and clicking back and forth. Is there
any way to export the properties information of a cube so that it would make
it easy to compare the two, like to an excel spreadsheet or somesuch. OR if
someone else knows what could be going on here, that would be great too!

Thanks in advance!
Bill

don't know if everything comes out...

http://www.microsoft.com/downloads/d...displaylang=en

--michael

"BK3" <zinck74 (AT) nospamhotmail (DOT) com> skrev i en meddelelse
news:OM9OlIOoEHA.2948 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

I'd recommend Tom Chester's Too "Cube Documentation Tool" which
documents everything MS Excel. It can be found @
http://www.tomchester.net/ under downloads.

"Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote