Access olap data sources through xmla
Project description
olap.xmla
This package is meant for accessing xmla datasources - see http://en.wikipedia.org/wiki/XML\_for\_Analysis
Building
In this directory, run:
python setup.py build
Testing
Tests are done against the Mondrian, 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).
Example
Here is an example how to use it:
import olap.xmla.xmla as xmla
p = xmla.XMLAProvider()
# mondrian
c = p.connect(location="http://localhost:8080/mondrian/xmla")
# or ssas - note that thhis needs setup on an iis
# also you'll probably need to authenticate using kerberos
# from requests_kerberos import HTTPKerberosAuth
# c = p.connect(location="https://my-as-server/olap/msmdpump.dll",
# sslverify="/path/to/my/as-servers-ca-cert.pem", auth=HTTPKerberosAuth())
# 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 {[Measures].ALLMEMBERS} * {[Time].[1997].[Q2].children} on columns,
[Gender].[Gender].ALLMEMBERS on rows
from [Sales]
"""
res = c.Execute(cmd, Catalog="FoodMart")
#return only the Value property from the cells
res.getSlice(properties="Value")
# or two props
res.getSlice(properties=["Value", "FmtValue"])
# to return some subcube from the result you can
# return all
res.getSlice()
# just the 4th column
res.getSlice(Axis0=3)
# same as above, SlicerAxis is ignored
res.getSlice(Axis0=3, SlicerAxis=0)
# return the data sliced at the 2nd and 3rd row
res.getSlice(Axis1=[1,2])
# return the data sliced at the 2nd and 3rd row and at the 4th column
res.getSlice(Axis0=3, Axis1=[1,2])
Using the procedural interface:
import olap.xmla.xmla as xmla
p = xmla.XMLAProvider()
c = p.connect(location="http://localhost:8080/mondrian/xmla")
s = c.getOLAPSource()
# import olap.interfaces as oi
# oi.IOLAPSource.providedBy(s) == True
s.getCatalogs()
s.getCatalog("FoodMart").getCubes()
s.getCatalog("FoodMart").getCube("HR").getDimensions()
s.getCatalog("FoodMart").getCube("HR").getDimension("[Department]").\
getMembers()
s.getCatalog("FoodMart").getCube("HR").getDimension("[Department]").\
getMember("[Department].[14]")
cmd= """
select {[Measures].ALLMEMBERS} * {[Time].[1997].[Q2].children} on columns,
[Gender].[Gender].ALLMEMBERS on rows
from [Sales]
"""
res=s.getCatalog("FoodMart").query(cmd)
res.getSlice()
Note
The contained vs.wsdl originates from the following package: http://www.microsoft.com/en-us/download/confirmation.aspx?id=9388 and was subsequently modified (which parameters go in the soap header) to work with the zeep.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Hashes for netas-xmla-with-dax-0.8.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4a365bcd420b4efa22766665b43f760b728e3c0bbcd2cd39219e7f648d2d8371 |
|
MD5 | 003588876000db46ee5a8c7e2de2cac9 |
|
BLAKE2b-256 | 6c159b2459711d7462df9d0a0665e2f34d07d00417e68abe937e4dbb43f35032 |