![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
|
From there I see a Levels collection but it is accessed via the CubeHierarchy.Hierarchy object: |
#2
| |||
| |||
|
|
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. |
#3
| |||
| |||
|
|
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 |
|
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 |
|
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. |
![]() |
| Thread Tools | |
| Display Modes | |
| |