Showing posts with label perform. Show all posts
Showing posts with label perform. Show all posts

Monday, February 13, 2012

Analysis services partitioning

All,
Is there a way within analysis services to perform a partition on an automated basis? Not sure if this is necessarily the best forum for my question. Apologies if it falls outside the scope of SQL server.
Any help is appreciated.
IsaacHi Issac,

There is an easy method for it.

You do need to have a DTS package within which you can have an
ActiveX script. Within the Script you can use DSO object for
creating partitions(Search Google for getting code for craeting partitions using DSO objects).

The DTS package can be scheduled at wahtever interval you want the partition to be created (If you need ur partition to be created on Time interval basis).
If you need your partition to be created logically (like depending upon the size of the cube...), then you can do these checks once again only throgh DSO code that can be scheduled to check the cube at some intervals.

Sunday, February 12, 2012

Analysis services connection from Data Source

Hello everybody.

I want to perform a Analysis Services Processing Task using a connection manager created from a Analysis Services data source. I create the data source using the Oledb provider for Analysis Services 9.0, and it works fine. Then I create a connection manager using the "New connection from data source" option, and it seems to create it ok.

The problem is that I can't then asign this connection to the Analysis Services processing task. I get the error:

"Connection Manager MyConectionManagerFromDataSource is not a Analysis Services Connection Manager"

However, if I create directly a connection manager using "New Analysis Services Connection" it works fine.

Is it at all possible to create a Analysis services connection from a Data Source to perform a Analysis Services Processing Task?

Thanks in advance,

Check the two Connection Manager that you have created. There must be some difference between them.

-Jamie

|||

Thanks Jamie.

I've been checking the connection strings, and there is a slight difference:

Analysis services connection manager:

Data Source=myserver;Initial Catalog=mycatalog;Provider=MSOLAP.3;Integrated Security=SSPI;Impersonation Level=Impersonate;

Connection manager from data source:
Provider=MSOLAP.3;Data Source=myserver;Integrated Security=SSPI;Initial Catalog=mycatalog;Impersonation Level=3

I've tried to change the Impersonation Level to Impersonate in the Data Source, but only integer values are alowed.

Also, in the connection manager type, I have MSOLAP90 for the AS connection manager, and OLEDB for the CM from Data source. I think this must be the issue, but I'm not able to change the connection manager type

Thanks again,