nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Data Load Completed Successfully But No Data On The Dashboards

Edwin-ACE

I ran a Data Load for Financial Analytics successfully, the DW tables are populated with about 150GB of data but on the Dashboards i do not have an results, any clue guys?

BI Apps: 11.1.1.10.1

OBIEE: 11.1.1.9.1

OS: Cent OS 7

DB: 12.1.0.2.0

Browser: Firefox

Regards

Edwin

Find more posts tagged with

Accepted answers

All comments

rmoff

Are you using BI Server caching? If so, have you purged the cache since your data load?

Edwin-ACE

rmoff,

Not using caching and have not cleared cache since the data load completed

Regards

Edwin

rmoff

Have you configured your RPD to read from the correct DB & Schema that you loaded the data to?

Edwin-ACE

I configured the RPD as per the Oracle Documentation, don't believe i missed out on anything, however these are some of the messages in the nqserver log file

[2016-07-19T13:07:25.352+03:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 36d883615cd52f62:-210a7ee3:155ff4fbcb0:-8000-0000000000005595,0:1:71] [tid: 9917d700] [nQSError: 27047] Nonexistent table: "Oracle BI Application Configuration".."biacm"."C_BIEE_CURR_CODE_LKP". [[

select

BIEE_CURR_TAG

FROM

"Oracle BI Application Configuration".."biacm"."C_BIEE_CURR_CODE_LKP"

WHERE

ISO_CURR_CODE = 'VALUEOF(NQ_SESSION.DOO_CURRENCY)'

and INT_LOC_IND = 'VALUEOF(BIEE_CURRENCY_INDICATOR)'

[nQSError: 13011] Query for Initialization Block 'BI DOO Currency Code' has failed.

]]

[2016-07-19T13:35:24.653+03:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 36d883615cd52f62:-210a7ee3:155ff4fbcb0:-8000-0000000000005798,0:1:5] [tid: 9894d700] [nQSError: 27002] Near <)>: Syntax error [nQSError: 26012] . [[

file: server/Metadata/NQSParser/Src/NQSPScanner.cpp; line: 2321

********** Task: 1. Running for (mls): 1 **********

Description: Execute logical request

User: weblogic

SessionID: 886505472

ProcedureID: 113

SQL Hash: 0x989ee0fc

SQL::{call SAGetSharedRequestKey('SELECT MIN("Financials - AP Transactions"."Payables Invoicing Business Unit"."Payables Invoicing Business Unit Name")')}

]]

Pedro F

That piece of your log already suggests that you probably not have the correct DB and/or schema configured in your RPD.

It says that the table doesn't exist so it isn't issuing a query to the correct schema. Not sure what you followed in the Oracle documentation but you need to make sure that whatever you have defined in the physical layer of your RPD for database/schema is the one where you have all the data that was loaded.

Edit: Just adding something else here. That specific init block it's trying to ru (BI DOO Currency Code) is retrieved from BIACOMP schema which is configured in the Database "Oracle BI Application Configuration" so check if your connection pool for this database is correctly defined. Also, check the same thing for Database "Oracle Data Warehouse" which is the one that should point to the schema where you have all the data you loaded.

Edwin-ACE

However the thing is if i actually do a simple analysis using the current subject area it retrieves data, but not on the pre-defined dashboards

[Deleted User]

Ok so I think you really need to check what's happening in the background in detail. Are you dashboards really retrieving nothing or are the actually failing because of un-instantiated variables? Or are they retrieving nothing because of variables instantiated with values not matching your actual data? What do the actual nqquery log files say? Does any WHERE clause get added due to prompt context? ....hundreds of questions for you to answer to find the root cause.

Edwin-ACE

I think my issue is the currency setup as all amounts appear as $0 as per screenshot below instead of local currency which is KES and correct amount

Pedro F

Get the physical query of a report you built and said it retrieves data. Do the same for a pre-built report and compare the queries. Identify the differences between them and go from there, you need to narrow it down, hard to say what the problem is otherwise.

[Deleted User]

Once more: NQQuery.log. Check it. Get the actual query being sent against the database. Extract the SQL. Run it.