I have a QV document which has a simple direct query embedded with no measures.
DIRECT QUERY DIMENSION AS_OF DETAIL COL_1, COL_2, COL_3, COL_4, COL_5
FROM DB.SCH.TABLE_NAME
WHERE AS_OF > '1/1/2016'
The document has a list box with dimension AS_OF and a table box which has dimension and all detail columns added. Everything is working well wherein when i select a different as_of in list box, table gets refreshed with data from database server.
Only problem is export to excel doesn't works. As soon as i click export to excel, table has big cross on it. Someone mentioned here that excel export wont work if you have measure in table box but i have no measure. QV documentation has no mention on this limitation.
Does anyone has any insight? Did i miss something?