dbTalk Databases Forums  

HELP going from DSO to Analysis Management Objects (AMO)

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


Discuss HELP going from DSO to Analysis Management Objects (AMO) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
NoNick
 
Posts: n/a

Default HELP going from DSO to Analysis Management Objects (AMO) - 07-12-2006 , 07:38 AM






I am changing some code from DSO to AMO.

In DSO there was a Levels collection on the Dimension (i.e, For Each
oLvl As DSO.Level In oDim.Levels). Where is this in AMO? Is this now
contained in the CubeHierarchyCollection?

For Each oHierarchy As Microsoft.AnalysisServices.CubeHierarchy In
oDim.Hierarchies

Quote:
From there I see a Levels collection but it is accessed via the
CubeHierarchy.Hierarchy object:

For Each oLvl As Microsoft.AnalysisServices.Level In
oHierarchy.Hierarchy.Levels

Any help would be appreciated. I am looking for anything online that
goes into more detail about going from DSO to AMO, too. I am doing
this because I have upgraded some cubes to AS2005 and now I am trying
to figure out where it put everything so I can better get a handle of
how it does things.

Thanks.



Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: HELP going from DSO to Analysis Management Objects (AMO) - 07-13-2006 , 04:24 AM






You are on the right track, in DSO dimensions had levels. In AMO, a
level belongs to a hierarchy, which in turn belongs to a dimension.

I have not seen much out there on going from DSO to AMO. There is the
AMOAdventureWorks sample (which is installed at C:\Program Files
\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO
\AMOAdventureWorks by default) - which has code showing how to build a
subset of the Adventure Works DW sample database using AMO.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1152707893.754949.305700 (AT) s13g2000cwa (DOT) googlegroups.com>,
michaeldavidcox (AT) gmail (DOT) com says...
Quote:
I am changing some code from DSO to AMO.

In DSO there was a Levels collection on the Dimension (i.e, For Each
oLvl As DSO.Level In oDim.Levels). Where is this in AMO? Is this now
contained in the CubeHierarchyCollection?

For Each oHierarchy As Microsoft.AnalysisServices.CubeHierarchy In
oDim.Hierarchies

From there I see a Levels collection but it is accessed via the
CubeHierarchy.Hierarchy object:

For Each oLvl As Microsoft.AnalysisServices.Level In
oHierarchy.Hierarchy.Levels

Any help would be appreciated. I am looking for anything online that
goes into more detail about going from DSO to AMO, too. I am doing
this because I have upgraded some cubes to AS2005 and now I am trying
to figure out where it put everything so I can better get a handle of
how it does things.

Thanks.



Reply With Quote
  #3  
Old   
MDC
 
Posts: n/a

Default Re: HELP going from DSO to Analysis Management Objects (AMO) - 07-17-2006 , 09:49 AM



Quote:
You are on the right track, in DSO dimensions had levels. In AMO, a
level belongs to a hierarchy, which in turn belongs to a dimension.
Thanks. Yeah, after running some tests I found this was where Levels
were being placed when going from DSO to AMO.

Quote:
I have not seen much out there on going from DSO to AMO. There is the
Wouldn't you think there would be a lot more, though? I mean, what
else did people use in their applications to talk to AS2000?

Quote:
AMOAdventureWorks sample (which is installed at C:\Program Files
\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO
\AMOAdventureWorks by default) - which has code showing how to build a
subset of the Adventure Works DW sample database using AMO.
I will check this out. Thanks.

MDC



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.