dbTalk Databases Forums  

Looking for detailed programming reference for AMO for SQL Server 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Looking for detailed programming reference for AMO for SQL Server 2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
max@kcicorp.com
 
Posts: n/a

Default Looking for detailed programming reference for AMO for SQL Server 2005 - 10-07-2006 , 05:09 PM






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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.