Источник:
http://olondono.blogspot.com/2008/08...-2005-for.html
==============
For use
Analysis Services 2005 with
Dynamics AX, we need to ensure that DSO (Decision Support Objects) is well configured. Take a look to the following post for more information (NOTE: this post refers to Project 2007 but it is applicable to AX):
http://www.pptspaces.com/msprojectre...ost.aspx?ID=25
Important steps:
1. Ensure you have installed the following components:
- Microsoft SQL Server Native Client
- Microsoft SQL Server 2005 Management Objects Collection
- Microsoft SQL Server 2005 Backward Compatibility Components
2. Create the old style shared folder (MSOLAPRepository$), normally in
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9 for example.
- Share this folder as
MSOLAPRepository$.
- Se permissions for
EveryOne or any
OLAP users group as
Change (they need permissions to modify folder's content).
- Set
Full control to
SQLServer2005MSOLAPUser$SERVERNAME$MSSQLSERVER. This user can be located in the
ServerName instance.
3. Copy
msmdrep.mdb to this location (DSO9). You can get a copy of this file from
http://www.pptspaces.com/msprojectre...es/msmdrep.zip
4. Configure data access connection and locks folders: (Open the
Analysis Services's properties dialog using the
SQL Server Mananagement studio and selection the option
"Show Advance (All) properties")
- Configure the
DSO\LocksDirectory property with the correct path, ex.
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9
- Configure the
DSO\ RemoteLocksDirectory property as
\\ServerName\MSOLAPRepository$\.
Here is the tip different from the original post.
- Configure the
DSO\ RemoteRepositoryConnectionString selecting the
Microsoft Jet 4.0 OLE DB Provider but setting the path as
\\ServerName\MSOLAPRepository$\msmdrep.mdb.
Here is another difference from the original post.
- Configure the
DSO\ RepositoryConnectionString property but in this case, use the full local path for the msmdrep.mdb file, ex.
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9\msmdrep.mdb
Thats all, try it, transfer and process some cubes.
Источник:
http://olondono.blogspot.com/2008/08...-2005-for.html