Looking for detailed programming reference for AMO for SQL Server 2005



I'm having difficulty porting a SQL Server 2000/DSO utility which
builds dimensions & cubes to SQL Server 2005 and AMO. I'm finding the
MS documentation of the object model and class library pretty weak.

Can anyone recommend good source material (web site, books, other)
which:
1) Give an in-depth description of the AS 2005 object model and
interrelationships, specifically with regards to dimensions,
hierarchies, attributes, levels, cubes, measure groups, measures,
measure group dimensions;
2) Document the semantics (not just the syntax) of the properties and
methods in the class, as well as pointers, constraints, and
interactions;
3) Have deeper programming samples for construction of more complex
dimensions and cubes than those offered by MS related to
AdventureWorks;
4) Have troubleshooting advice for understanding and correcting
problems for various error conditions (I can't even find a way to
research an error message.)

I paid to get support from MS on these questions, but they weren't very
helpful.

Thanks very much for any help.

.



Relevant Pages

  • Re: Im looking for a metadata cube/dimension dependency report
    ... I have documentation that would help rebuild ... Even though I told it to ignore 1/2 dozen cubes, ... There is no mapping of what dimensions are used in what cubes -- only ... -- Hope to fix that bug. ...
    (microsoft.public.sqlserver.olap)
  • Analysis Manager Operations extremely slow
    ... Our data warehouse source is in Oracle 9i. ... cubes each with about 9 regular dimensions, ... Each of the cubes have many partitions. ... I migrated the repository to a local SQL Server instance ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... > cubes each with about 9 regular dimensions, ... > I checked the mdb repository size to be close to 10MB. ... I migrated the repository to a local SQL Server instance ...
    (microsoft.public.sqlserver.olap)
  • Re: Processing of complex AS 2005 DBs - only reliable from BI Dev
    ... Could you run SQL Profiler and make sure that this is happening? ... You would see at the beginning statements to process all dimensions. ... is there anything special to cubes that fail? ... SQL Server Management studio. ...
    (microsoft.public.sqlserver.olap)
  • Re: Processing of complex AS 2005 DBs - only reliable from BI Dev
    ... What's non-standard in our cubes is the extended use of Fact Dimensions ... The source database is SQL Server 2005 db. ... From Management studio if you select Process Full, ...
    (microsoft.public.sqlserver.olap)