603
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!
STATUS DETAILS
Needs Votes

Comments

S

This needs to be added urgently and should be core functionality.

Please add ASAP

S

Please

S

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!

S

Please fix this quickly

S

It doesn't make any sense that Direct Query and import mode treat the dates differently.

S

Needs to be implemented the same as Data Import

S

This needs to be implemented. The workarounds are extremely frustrating.

S

Please allow this feature, it would avoid creating custom columns at all time.

S

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.

S

Help, I really need the date hierarchy with direct query.