OLE DB Datenquellen für OLAP Services

5. Oktober 2015 von Centron GmbH

Microsoft OLE DB für Online Analytical Processing (OLAP) ist eine Sammlung von Objekten und Schnittstellen, die OLE DB ermöglichen, multidimensionale Datenspeicher anzusprechen.

Für ADOMD.Catalog:

oCat.ActiveConnection = _
        "Provider=MSOLAP;" & _
        "Data Source=myOLAPServerName;" & _
        "Initial Catalog=myOLAPDatabaseName"

oCat.ActiveConnection = _

"Provider=MSOLAP;" & _

"Data Source=myOLAPServerName;" & _

"Initial Catalog=myOLAPDatabaseName"

Für ADOMD.Catalog (mit Angabe einer URL):

oCat.ActiveConnection = _
        "Provider=MSOLAP;" & _
        "Data Source=http://myServerName/;" & _
        "Initial Catalog=myOLAPDatabaseName"

oCat.ActiveConnection = _

"Provider=MSOLAP;" & _

"Data Source=http://myServerName/;" & _

"Initial Catalog=myOLAPDatabaseName"

Für Excel PivotTable:

With ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal)
    .Connection = "OLEDB;" & _
                  "Provider=MSOLAP;" & _
                  "Location=myServerDataLocation;" & _
                  "Initial Catalog=myOLAPDatabaseName"
    .MaintainConnection = True
    .CreatePivotTable TableDestination:=Range("A1"), _
                      TableName:= "MyPivotTableName"
End With

With ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal)

.Connection = "OLEDB;" & _

"Provider=MSOLAP;" & _

"Location=myServerDataLocation;" & _

"Initial Catalog=myOLAPDatabaseName"

.MaintainConnection = True

.CreatePivotTable TableDestination:=Range("A1"), _

TableName:= "MyPivotTableName"

End With