Process SSAS OLAP cube via Python

Question

I have an OLAP cube on SSAS (and XMLA script for processing). How can I call processing it via Python script? The only things I can find are about getting data from cubes (mdx/etc), and some popular libraries are really old (for example, xmla was last updated in 2013).

Please provide enough code so others can better understand or reproduce the problem. — Community
– Community Bot, Commented Oct 27, 2023 at 9:09

Peter Kazmir · Accepted Answer · 2023-11-12 17:59:02Z

0

For loading pd df with mdx query you can use mdx-to-pd. You will provide the mdx query and connection and it will return the dataframe you will need powerbi installed and you will need to have access to cube

from mdx_to_pd import mdx_retriever

connection = "Data Source=https://biserver.company.com/database/;Catalog=Model;"
query = """
        SELECT NON EMPTY [Measures].[Order Count] ON COLUMNS,
        NON EMPTY ([Markets].[Country].[Country]) ON ROWS
        FROM [OLAP_CUBE]
        """
# returns pd.DataFrame()

df = mdx_retriever(query, connection)

answered Nov 12, 2023 at 17:59

Peter Kazmir

492 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Process SSAS OLAP cube via Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related