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.





      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.....