olap Interface to OLAP DBs
Download

olap Ranking & Summary

olap Tags

database Python library Python Python interface OLAP

olap Description

olap is a Python module that provides interfaces to access OLAP DBs for use in packages like olap.xmla.BUILDIn this directory, run: python setup.py buildTESTINGTests are done against the Mondrian and SSAS XMLA providers. The testsDiscover module tests behavior with different XMLA providers with the Discover command while testsExecute does the same with the Execute command.Note that you likely need to modify the sources if you want to test yourself since they contain specifics (namely the location of the services and names of the data sources).SAMPLEHere is an example how to use it:: import olap.xmla.xmla as xmla p = xmla.XMLAProvider() c = p.connect(location="http://localhost:8080/mondrian/xmla", doKerberos = False) # getting info about provided data print c.getDatasources() print c.getMDSchemaCubes() # for ssas a catalog is needed, so the call would be like # get a catalogname from a call to c.getDBSchemaCatalogs() # c.getMDSchemaCubes(properties={"CATALOG":"a catalogname"}) # execute a MDX (working against the foodmart sample catalog of mondrian) cmd= """select {.ALLMEMBERS} * {...children} on columns, ..ALLMEMBERS on rows from """ res = c.Execute(cmd, Catalog="FoodMart") res.getSlice(property="Value") #return only the Value property from the cells # to return some subcube from the result you can res.getSlice() # return all res.getSlice(Axis0=3) # carve out the 4th column res.getSlice(Axis0=3, SlicerAxis=0) # same as above, SlicerAxis is ignored res.getSlice(Axis1=) # return the data sliced at the 2nd and 3rd row res.getSlice(Axis0=3, Axis1=) # return the data sliced at the 2nd and 3rd row in addition to the 4th column Product's homepage

olap Related Software