Hi there,

I have a analysis service database of 20GB. I want to send the database
basically cube structure and dimensions to client - without any data in
the cubes. That will reduce the size of the database.

Is this possible?

Thanks,

Ranj

do you use AS2000 or 2005?

in 2005 you can generate the XML/A script which contains only the metadata.
you can also send the .asdatabase file (under the bin folder of a visual
studio solution; if your database definition is under a solution and don't
edited directly from the server)

in AS2000, you can copy/paste the database into the same server (or another
server), this copy is empty (no data); backup this copy.

"Ranj" <ranjitsudan (AT) gmail (DOT) com> wrote

Also processing ROLAP without aggregations will give you a cube with no
data to archive...

(the only reason I can see that this might be a good alternitive to
Copy/Paste is if you actually need the name to remain the same. (an
issue in AS 2000) even then you could copy/paste/delete orig cube/paste
back to orig name....)

I am using AS 2000. With copy and paste i still need to reprocess the
cube in order to have cube available on my front end for analysis.

How can i have a cube with no data but still available for analysis?

Jeje wrote:

ok

you can also copy the data folder.
stop AS on both server, copy the data folder from server A to server B.

if your repository is stored into the mdb (Access) database, copy the
repository, else, you have to copy the data from the MSDB databases (SQL
Server storage) to make sure that the repository is in sync. between the 2
servers

finally restart the services.


"Ranj" <ranjitsudan (AT) gmail (DOT) com> wrote

Back to the Rolap solution... once you unarchive on server B the cube
will still be process and may be queried. Then start Reprocess with
Lazy Aggregation= True and you cube never actually go down. (Using
Lazy aggregations, cube will process a bit slower though)
Byron