<div>
In BIP among report's properties there is Default Data Source. I think that it wasn't changed in your case.
</div>


In BIP among report's properties there is Default Data Source. I think that it wasn't changed in your case.

<div>
I would suggest move this question to PAQ with points refunded.
</div>


I would suggest move this question to PAQ with points refunded.

<div>
This question has not been answered, i found the solution my self,, this question should go to PAQ and points be refunded. I mentioned the answer as i turned of the OBIEE Cache and everything got normal.
</div>


This question has not been answered, i found the solution my self,, this question should go to PAQ and points be refunded. I mentioned the answer as i turned of the OBIEE Cache and everything got normal.

<div>
Bawer, put here your solution and then go to Community support<br />
<a href="https://www.experts-exchange.com/Other/Community_Support/" rel="ugc nofollow">https://www.experts-exchange.com/Other/Community_Support/</a><br />
and ask moderator to accept your solution and refund points to you.
</div>


Bawer, put here your solution and then go to Community support
https://www.experts-exchange.com/Other/Community_Support/ [https://www.experts-exchange.com/Other/Community_Support/]
and ask moderator to accept your solution and refund points to you.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have setup windows server 2003 and installed the OBIEE 10.1. For weeks i am working on this server and all reports are ok although the ODBC connection was to one of our TEST oracle &nbsp;schema and now when the live schema is up and running i changed the ODBC and JDBC (for BIP) the OBIEE reports are still shown with old data as of test schema,<br />
<br />
My question is that where OBIEE is fetching this data from , is there any cache involved ?<br />
whereas the ODBC connection is already pointing to new oracle schema.<br />
<br />
Thanks
</div>
</div>


Hi,

I have setup windows server 2003 and installed the OBIEE 10.1. For weeks i am working on this server and all reports are ok although the ODBC connection was to one of our TEST oracle  schema and now when the live schema is up and running i changed the ODBC and JDBC (for BIP) the OBIEE reports are still shown with old data as of test schema,

My question is that where OBIEE is fetching this data from , is there any cache involved ?
whereas the ODBC connection is already pointing to new oracle schema.

Thanks

OBIEE Connection

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Productivity software is application software dedicated to producing information, such as documents, presentations, worksheets, databases, charts, graphs, digital paintings, electronic music and digital video. Most common programs and suites such as Microsoft Office and LibreOffice have their own topics. Office suites, which brought word processing, spreadsheet, and relational database programs to the desktop in the 1980s, are the core example of productivity software, but they can include communications software, personal information managers, groupware and log analysis software.