0 Replies Latest reply: Sep 13, 2017 10:41 AM by Andres Prato RSS

    I am doing a Direct Query, but get error in chart when analyzing data

    Andres Prato

      When I try to put my data in a table, this error comes up. I don't understand since I created the same report without Direct Query and works fine. I am trying to use the Direct Queries to see how they work

       

       

      Screen Shot 2017-09-13 at 10.40.18 AM.png

      The query goes like:

           DIRECT QUERY
                dimension

                     memberId,

                     date,

                     other fields

               from tableA, tableB, tableC, factTable

               where tableA.id = factTable.id

                and tableB.clientId = factTable.clientId

                and tableC.otherId = factTable.otherId

       

      Thank you,

       

      Andres