olap.py

import olap.xmla.xmla as xmla
provider = xmla.XMLAProvider()
con = provider.connect(location='http://{server}/OLAP/msmdpump.dll'.format(server='YOUR SERVER IP'))

# Verify that we are connected
print c.getMDSchemaCubes()

# Write MDX query
cmd = """SELECT NON EMPTY { [Measures].[Count] } ON COLUMNS FROM [OLAP]"""
cur = con.Execute(cmd)

# get all data:
cur.getSlice()

# get Values only:
cur.getSlice(properties="Value")