0 Replies Latest reply: Dec 4, 2016 9:52 AM by NIKHIL BALANI RSS

    Direct Discovery - Issue with export to Excel.

    NIKHIL BALANI

      Hi Experts,

      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?

       

      Thanks all in advance!