Public Class Form1
    Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    Friend WithEvents txtServer As System.Windows.Forms.TextBox
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
    Friend WithEvents btnGo As System.Windows.Forms.Button
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.txtServer = New System.Windows.Forms.TextBox
        Me.Label1 = New System.Windows.Forms.Label
        Me.Label2 = New System.Windows.Forms.Label
        Me.TextBox1 = New System.Windows.Forms.TextBox
        Me.btnGo = New System.Windows.Forms.Button
        Me.SuspendLayout()
        '
        'txtServer
        '
        Me.txtServer.Location = New System.Drawing.Point( 128 ,  24 )
        Me.txtServer.Name = "txtServer"
        Me.txtServer.Size = New System.Drawing.Size( 152 ,  20 )
        Me.txtServer.TabIndex =  0 
        Me.txtServer.Text = "localhost"
        '
        'Label1
        '
        Me.Label1.Location = New System.Drawing.Point(24, 24)
        Me.Label1.Name = "Label1"
        Me.Label1.TabIndex = 1
        Me.Label1.Text = "Server"
        '
        'Label2
        '
        Me.Label2.Location = New System.Drawing.Point( 24 ,  56 )
        Me.Label2.Name = "Label2"
        Me.Label2.TabIndex =  3 
        Me.Label2.Text = "Database"
        '
        'TextBox1
        '
        Me.TextBox1.Location = New System.Drawing.Point(128, 56)
        Me.TextBox1.Name = "TextBox1"
        Me.TextBox1.Size = New System.Drawing.Size(152, 20)
        Me.TextBox1.TabIndex = 2
        Me.TextBox1.Text = ""
        '
        'btnGo
        '
        Me.btnGo.Location = New System.Drawing.Point( 128 ,  216 )
        Me.btnGo.Name = "btnGo"
        Me.btnGo.TabIndex =  4 
        Me.btnGo.Text = "Script!"
        '
        'Form1
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
        Me.ClientSize = New System.Drawing.Size(292, 273)
        Me.Controls.Add(Me.btnGo)
        Me.Controls.Add(Me.Label2)
        Me.Controls.Add(Me.TextBox1)
        Me.Controls.Add(Me.Label1)
        Me.Controls.Add(Me.txtServer)
        Me.Name = "Form1"
        Me.Text = "MSAS Scripter"
        Me.ResumeLayout(False)

    End Sub

#End Region

    Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
        Dim dsoServer As New DSO.Server
        Dim dsoDB As DSO.MDStore
        Dim dsoCube As DSO.MDStore
        Dim dsoMea As DSO.Measure
        Dim dsoCmd As DSO.Command

        ' Create a connection to the Analysis server.
        dsoServer.Connect(Trim(txtServer.Text))

        ' Step through the databases in the MDStores collection
        ' of the server object.
        For Each dsoDB In dsoServer.MDStores
            'Debug.WriteLine("DATABASE: " & dsoDB.Name & " - " & _
            'dsoDB.Description)

            'Step through the cubes in the database collection.
            For Each dsoCube In dsoDB.MDStores
                Dim sCmdType As String
                For Each dsoCmd In dsoCube.Commands
                    Select Case dsoCmd.CommandType
                        Case DSO.CommandTypes.cmdCreateAction
                            sCmdType = "Action"
                        Case DSO.CommandTypes.cmdCreateCellCalculation
                            sCmdType = "Cell Calculation"
                        Case DSO.CommandTypes.cmdCreateMember
                            sCmdType = "Member"
                        Case DSO.CommandTypes.cmdCreateSet
                            sCmdType = "Set"
                        Case DSO.CommandTypes.cmdUnknown
                            sCmdType = "Unknown"
                        Case DSO.CommandTypes.cmdUseLibrary
                            sCmdType = "Use Library"
                    End Select

                    Debug.WriteLine(dsoDB.Name & "|" & dsoCube.Name & "|" & dsoCmd.Name & "|" & sCmdType & "|" & dsoCmd.Statement & "|" & dsoCmd.Description & "#")
                Next

                'Step through measures for the cube.
                Dim AggType As DSO.AggregatesTypes, sAggType As String

                For Each dsoMea In dsoCube.Measures
                    Select Case dsoMea.AggregateFunction
                        Case DSO.AggregatesTypes.aggSum
                            sAggType = "Sum"
                        Case DSO.AggregatesTypes.aggCount
                            sAggType = "Count"
                        Case DSO.AggregatesTypes.aggMin
                            sAggType = "Min"
                        Case DSO.AggregatesTypes.aggMax
                            sAggType = "Max"
                        Case DSO.AggregatesTypes.aggDistinctCount
                            sAggType = "Distinct Count"
                    End Select

                    Debug.WriteLine(dsoDB.Name & "|" & dsoCube.Name & "|" & dsoMea.Name & "|" & sAggType & "|" & dsoMea.SourceColumn & "|" & dsoMea.Description & "#")
                Next
            Next
        Next


    End Sub
End Class