0 Replies Latest reply: Dec 16, 2015 4:07 PM by Niitn A Pinto RSS

    Error when using Direct Discovery saying "Direct query returned empty result set"

       

      Hi All,

       

      I am trying to pass a dynamic value$(vMonth) to the FROM clause of the DIRECT QUERY in the script. It works fine for the initially loaded month's data. But it’s throwing an error when I select a different month, which is passed through the variable $(vMonth) to the FROM clause to fetch the corresponding Months data. Here is the code where I am using the $(vMonth) in the FROM clause.

       

      Table:
      DIRECT QUERY
      DIMENSION
      .

        .

      MEASURE
      ………

      FROM schema.$(vMonth);

       

      This is working only if I reload the app after a different month is selected. Is there a way to fetch the data corresponding to the value of $(vMonth) without reloading from the DIRECT QUERY ?

       

      Below is the error I get…..

       

       

      Thanks in advance.....