So currently I use MS Excel to explore and pull some data from a SAP Query I have access using SBOP Analysis tool in Excel.
Now I need to automate this process and what I have done is use a Macro to connect and refresh the data daily, which is good for now but is very prone to errors ie. sometimes the macro fails and I need to refresh it manually.
What I would like to do is perhaps use Python to connect to this SAP Query (It is a cube with dimensions and measures) the same way I do it with SBOP Analysis. Is this even possible?
I have found using the PyRFC library could be a solution however I don't think is works for the type of data source I need, or perhaps I haven't found a good example.
Thanks,