Sam Bloggs on 14 Jun 2016 21:06:14
When using direct query you should be able to change a date axis to show only the month. This works using excel or when doing a transform but neither of these are possible using DirectQuery. Even workarounds like FORMAT can't be used with direct query. This really needs fixing!
- Comments (55)
RE: Improve Direct Query Date Time Handling
Please
RE: Improve Direct Query Date Time Handling
Direct query to SAP BW needs to recognize BW date fields as date and not as text. That's basic and real pain in the ass, please fix as soon as possible!
RE: Improve Direct Query Date Time Handling
Please fix this quickly
RE: Improve Direct Query Date Time Handling
It doesn't make any sense that Direct Query and import mode treat the dates differently.
RE: Improve Direct Query Date Time Handling
Needs to be implemented the same as Data Import
RE: Improve Direct Query Date Time Handling
This needs to be implemented. The workarounds are extremely frustrating.
RE: Improve Direct Query Date Time Handling
Please allow this feature, it would avoid creating custom columns at all time.
RE: Improve Direct Query Date Time Handling
This is definitely needed, but a workout we use is to bring in a date dimension table for each date we need a hierarchy on. It works when you're only utilizing a few dates.
RE: Improve Direct Query Date Time Handling
Help, I really need the date hierarchy with direct query.
RE: Improve Direct Query Date Time Handling
Yes. This is limiting drill-down capability with Direct Query.