Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Data Load Completed Successfully But No Data On The Dashboards
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
Answers
-
Are you using BI Server caching? If so, have you purged the cache since your data load?
0 -
rmoff,
Not using caching and have not cleared cache since the data load completed
Regards
Edwin
0 -
Have you configured your RPD to read from the correct DB & Schema that you loaded the data to?
0 -
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")')}
]]
0 -
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.
0 -
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
0 -
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.
0 -
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
0 -
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.
0 -
Once more: NQQuery.log. Check it. Get the actual query being sent against the database. Extract the SQL. Run it.
0