This content has been marked as final. Show 3 replies
Yes.you can find usage tracking files under below path
Obiee11160 install drive D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample
for the schema you can find it below
In obiee18.104.22.168.0 version Usage Tracking S_NQ_ACCT and Scheduling objects are moved from the target database area to RCU schema and also new column added and several column types changed.
You can also download usage tracking RPD from this link
Otherwise better to copy the 11g provided Usage tracking RPD layers and merge it with your upgraded RPD.However still Usage Tracking customization required.
For more refer:http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/usage_track.htm
Usage tracking table structure has changed in 11g.The table should have all the columns listed here,
You have the tables readily imported in the rpd uploaded in this blog,
It should be in your middleware home directory \instances\whatever\bifoundation\OracleBIServerComponent\coreapplication_obis1\schema
Hope this help's
This question is a follow-up - forgive me, as I'm new to OBIEE, and the question may not seem intelligent.
When we configure OBIEE to pull information out of our data warehouse, we are being told by customer that we are not allowed to create RCU schemas on the data warehouse database.
We will need to use summary advisor to create aggregates.
What steps would I need to do to be able to use Summary Advisor is my RCU schemas are on a different database?