A pythonic approach to query SSAS data models
Project description
Pyadomd
A pythonic approach to query SSAS data models.
Query SSAS Tabular model
from pyadomd import Pyadomd
from sys import path
path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\150')
conn_str = 'Provider=MSOLAP;Data Source=localhost;Catalog=AdventureWorks;'
query = """EVALUATE Product"""
with Pyadomd(conn_str) as conn:
with conn.cursor().execute(query) as cur:
print(cur.fetchall())
Integrates easily with pandas
from pandas import DataFrame
with Pyadomd(conn_str) as conn:
with conn.cursor().execute(q) as cur:
df = DataFrame(cur.fetchone(),
columns=[i.name for i in cur.description])
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
pyadomd-0.0.2.tar.gz
(4.1 kB
view hashes)