Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BI does not return actual results

marcoDec 5 2012 — edited Dec 5 2012

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?

This post has been answered by prassu on Dec 5 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2013

Added on Dec 5 2012

#bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

3 comments

127 views