StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSQL Server 2005 Analysis Service (SSAS) Partial Synchronization
text
Body
copied!<p>I'm new to SSAS (this is my first project that involves ssas).</p> <p>I have a regular a SQL Server 2005 server (say Blah) that run database instance and sql server analysis service. I want to synchronize some of the data in Blah (based on some condition) to another server, Blah2. Partial data sync is quite straightforward with the help of replication server. However, I'm not sure how to do a partial data synchronization for the analysis service.</p> <p>I have a table in Blah database that list all of the cubes in its analysis service. I then need to filter this table to list all the necessary cube and this is ok. But I'm sure how to continue from there. </p> <p>I've looked into the SSAS Database Sync Wizard but I couldnt find any command line tools for this or a way to run this as procedure in SQL Script (I will need to do this as a regular sql server job, so it's necessary not to rely on gui). Even if I want to use the gui, there doesnt seems to be a way to filter the cube/measurement from the gui.</p> <p>I'm thinking of getting the cube, measurement, data source view, etc dynamically but I cant find a way to get these definitions dynamically from sql script. I'm trying to do simple openquery to get list of cube in sql server screen with this (olap_server is a linked server to the ssas):</p> <pre><code>select * from openquery(olap_server, 'select [CATALOG_NAME] from $system.dbschema_catalogs') </code></pre> <p>with no luck. I got the "An error occurred while preparing the query "select [CATALOG_NAME] from $system.dbschema_catalogs" for execution against OLE DB provider "MSOLAP" for linked server "olap_server"." error instead.</p> <p>Is there any straightforward way to do this task? </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload