search

abilian / olapy

OlaPy, an experimental OLAP engine based on Pandas
GNU Lesser General Public License v2.1
103 stars 19 forks source link

Add filter field #34

Open ghost opened 3 years ago

ghost commented 3 years ago

Hello, I tried put a field in filter, an excel shut down

Also trying through a pivot table on column listing

It throws an internal error on movetonewhier

Is there a fix ?

mouadhkaabachi commented 3 years ago

See #9

ghost commented 3 years ago

Do you have any hint to explore to implement that ?

mouadhkaabachi commented 3 years ago

we need to parse the mdx query generated by excel and then implement the xmla spec related to this query, it is not an easy task

ghost commented 3 years ago

Ok i see thank you, I'd have a last question if it's possible, what kind of version did you take to develop ? I think you took one from 2009 with basic features, and many new features were developed since (https://docs.microsoft.com/en-us/openspecs/sql_server_protocols/ms-ssas/854a72f2-d637-4be3-b60f-6a44422e80c9)

mouadhkaabachi commented 3 years ago

I took version 14.0 when I started to develop it

ghost commented 3 years ago

Thank you for answers, I'll update your package