3 Replies Latest reply: Dec 5, 2012 4:30 AM by prassu RSS

    BI does not return actual results

    marco
      Hi all,

      I'm just on my first step, trying to understand how Oracle BI EE works.

      I'm at http:// [ our bi server ] :9704/analytics/saw.dll?IssueRawSQL it is Administration -> Issue SQL section.

      My sql statement
      select id, userid from zvit.marco_test1
      returns
      "MARCO_TEST1"."ID"     "MARCO_TEST1"."USERID"
      double     double
      1.00     2.00
      This information was actual yesterday, but today toad returns another result:
      select id, userid from zvit.marco_test1
              ID     USERID
      ---------- ----------
               0          2
      1 row selected.
      Is it some cashe? How do I get actual result?