Anybody can share the way to administer AS2005 using DSO?
AMO (Analysis Management Objects) is the object model for administering AS2005 and it's highly recommended to be used instead of DSO 8.5 shipped in AS2005 (DSO 8.5 is DSO 8.0 with SP4 fixes and additions to support AS2005 connectivity).
DSO 8.5 is for administering databases who are:
1. migrated from AS2000 to AS2005
and
2. are not edited/maintained with the AS2005 tools or AMO
Because of the changes between AS2000 and AS2005, a total DSO compatibility with AS2005 was not obtained and these are the restrictions:
- DSO 8.5 sees only the databases from the repository (DSO8’s repository)
- DSO 8.5 does not see the databases on the AS2005 server, he only reads the repository and deploys on the AS2005 server when processing an object; in other words, new databases on AS2005 (created with AS2005 tools) are not exposed through DSO 8.5
- DSO 8.5 overwrites (if in conflict) the databases from AS2005; for example if you created a database on AS2005 with DSO 8.5, then you edit it with AS2005 tools, when using DS0 8.5 the database will be overwritten with its version from the DSO repository (the AS2005 tools do not update the DSO repository)
- Because of changes between the AS2000 and AS2005 models, DSO 8.5 has an un-optimal design, certainly not having the AMO’s speed for comparable tasks
Please note that sometimes DSO 8.5 is referred to as DSO9 (since it works with AS2005 aka AS 9.0). I am calling it DSO 8.5 because that's the actual file version.
To setup DSO 8.5 to work with AS2005, you need to:
- have the DSO repository (from AS2000); usually this is the msmdrep.mdb file from "%ProgramFiles%\Microsoft Analysis Services\Bin"
- setup AS2005 to specify connection string to the DSO repository and also the locks folder; to do this, stop the AS2005 server, edit the msmdsrv.ini file (from the AS2005 installation folder), look for the <DSO> xml section:
<DSO>
<RemoteRepositoryConnectionString/>
<RepositoryConnectionString/>
<RemoteLocksDirectory/>
<LocksDirectory/>
</DSO>
- specify values for those properties (to see what they mean, please check books online "ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uas9/html/75e062bd-7f24-43b0-8b0b-d48437d3a116.htm")
- start the AS2005 server
- connect with DSO 8.5 (for example using Analysis Manager from AS2000); please remember you will see the databases from the repository and not the actual databases from the AS2005 server
Adrian Dumitrascu.
|||What about this errror that I get after connecting to the repository with DSO:
HAIdcom.clsDrillThrough.GetDTColumnNames(): Path not found
|||Hmm - so it seems that using DSO from an application against AS2005 is not a good idea? It sound slike from your description that the use of DSO will overwrite any modifications made directly using SQL Mgmt Studio? Thats not good.I have been trying to use DSO also in this scenario - where is the RepositoryConnectString supposed to point to - and what provider shpuld be used? The MS documentation gives no hints to this, when I try pointing to the access mdb you suggested I get:
Errors in the OLE DB provider. The data source or location is not valid. Provide a valid server to which to connect.
If I point to the Analysis server database I want to connect to using the new Analysis 9.0 provider I get:
Query (1, 10) Parser: The syntax for ',' is incorrect.
I would have thought there would be more people trying to do this and getting similar issues?
Any help just to get back to previous functionality would be greatly appreciated, thanks.
|||Hi All.
The DSO has been replaced by the AMO.
But the problem that arises with this is as follows.
DSO was COM. So, VBA code could use the DSO to access data/metadata of AS2000.
Now, I intend to access the same in VBA/Excel.
Any idea how I could do this, since AMO is not a COM class, and can be used thru .NET.
Essentially, my intention is to document a cube of AS2005 and throw the metadata into Excel sheets.
Thanx in advance.|||Hi,
thank you for the details.
I use the DSO Object for AS2000. Where can i find the DLL for DSO 8.5 ?
I use the Interop.DSO.dll for DSO and AS 2000 and have to set e new reference in the project for DSO 8.5. With the old DSO it is not possible to acces the AS 2005 :-(
Hop somebody can help me
|||
fantasimus wrote:
Hi,
thank you for the details.
I use the DSO Object for AS2000. Where can i find the DLL for DSO 8.5 ?
I use the Interop.DSO.dll for DSO and AS 2000 and have to set e new reference in the project for DSO 8.5. With the old DSO it is not possible to acces the AS 2005 :-(
Hop somebody can help me
Fantasimus, please read the earlier posts.
The AMO is what you should be using to access SSAS (AS2005).
And as I have said earlier, the AMO is a .NET library unlike the DSO which was COM.
However, using Visual Studio 2005 Tools for Office version, one can do VBA like work, since office project templates are available with VSTO.
And then, the programming can be in c# or vb.net
|||Thanks for all comments.
It seems our work is proved to be correct. As these reasons Adrian refered, we never used DSO any more, neight DSO 8.5. But we made the wrapper for AMO using .NET, and CCW it to make COM visiable. That's saving time to update millions of codes. For balance to our worktime, at some points, we wrapper our business layer functions directly.
Hope our solution and choice will make sense to others who are willing to lift SQL2005, thanks!
Hello,
I am testing the Beta Version of MS Project Server 2007, using Analysis Services 2005 to try to build an OLAP cube. I am consistently getting the following error (see below) and this forum is the only place that I can find any information on it. I'm not a developer, so I'm not sure how (or if) this issue relates to the DSO problem that you all discussed above. Do you have any insight?
=====Process Completed=====
[11/6/2006 2:11 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Query (1,10) Parser: The syntax for
',' is incorrect.
Thanks,
Brian
|||
Hi Brian,
Did you get a solution for the error "Query (1,10) Parser: The syntax for
',' is incorrect. "?
I'm also getting the same error and clueless of what should be done.
Thanks
Umanga.
Posted By: bciampa on 11-07-2006 8:48 PM UTC
Hello,
I am testing the Beta Version of MS Project Server 2007, using Analysis Services 2005 to try to build an OLAP cube. I am consistently getting the following error (see below) and this forum is the only place that I can find any information on it. I'm not a developer, so I'm not sure how (or if) this issue relates to the DSO problem that you all discussed above. Do you have any insight?
=====Process Completed=====
[11/6/2006 2:11 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Query (1,10) Parser: The syntax for
',' is incorrect.
Thanks,
Brian
Hi guys! Have you got any solution for that error message(Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Query (1, 10) Parser: The syntax for ',' is incorrect.)?
Pls. help if you have one
Thanks
|||Hi,
I don't have a straight answer for this problem, but let's try to debug it.
You are using DSO version 8.5 to connect to Analysis Services 2005 (after you configured AS2005 to setup the DSO-related server properties, the connection string to the repository and the lock directory).
You are able to connect, to read all the objects (although please remember that you read all the objects from the repository, not from the real AS2005 server).
And you get the error when you try to process an object ? If yes, let's try to see what commands is DSO sending to the AS2005 server before the error.
- start SQL profiler for Analysis Services
- re-run the minimal DSO code that would generate the error
- in profiler you should see the commands that DSO sent to server just before the error
- I assume you will have 2 commands: an Alter statement (for the Database probably, or maybe for a Partition if you process a Partition) followed by a Process statement, the Alter succeeds, but the Process fails; but let's check these assumptions first
Adrian Dumitrascu
|||Any one has idea how to create roles and permissions for a SSAS cube using VB and then using AMO
I basically want to create the VB script and then want to run it through cmd prompt
please, let me know all the stepsto do all this
thanks
|||This seems to be unrelated with the DSO in AS2005, there are these other threads about creating roles and permissions:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1795829&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1798355&SiteID=1
No comments:
Post a Comment