Using pd.read_sql with date values doesn't populate correctly in cube

MicroStrategy / mstrio-py

Python integration for MicroStrategy

Apache License 2.0

90 stars 60 forks source link

Using pd.read_sql with date values doesn't populate correctly in cube #3

Closed narquette closed 3 years ago

narquette commented 5 years ago

Steps:

1) Get data with panda.read_sql including a date value 2) Add it to a cube using create_dataset function 3) Go to MicroStrategy / My Report 4) Add data to report 4) Date values will not appear in the report

Expected: Date value should comes into a report without issue

ssainz commented 5 years ago

Thanks @narquette , pull request created for a fix for this: https://github.com/MicroStrategy/mstrio-py/pull/5