Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

No Cache hit

629048Sep 26 2008 — edited Oct 7 2008
Hi,

i've a report cached with an ibot, but when i open the report on my dashboard it doesn't get it from the cache (with dashboard prompt).
I also copied the report and made a filter on it, what normally is done by the dashboard prompt and tried it that way. And then it works for that filtervalue.

So what i want i to run the query whitout any filter in the cache and then when the user opens it in the dashboard with a prompt it should get it filtered out of the cache.

Regards,

Osman

Comments

628531
How many rows does the report return without the filter? If it's to high (100k?) then OBIEE will not add to the cache!

regards

John
http://obiee101.blogspot.com/
629048
Hi JOhn,

sorry for the reply, but the report without filter is big, but also tried with a smaller one. This is what i did. The report without filter has information from 12 departments. So i made a report with a filter for 2 department (where departmentno in (dep1,dep2))

When i try to open the report for one of these department it still doesn't get a cache hit.

Any other idea what i could do?

Osman
612229

Are you using any variables in your queries?

Mike

[http://www.biconsultinggroup.com]

629048
Hi Mike,

no there are no variables used in the query. The only thing is that there are column with a formula.

regards,

Osman
612229
If no variables are being used I've had mixed results when running a query for all of the records and then running a 2nd query that's a subset of the 1st query. The documentation states that OBI should used the cache entry created by the 1st query to produce the results for the 2nd query but this isn't always true.

Mike

http://www.biconsultinggroup.com
629048
OK, but is this a bug? Is there a workaround? The only thing what i will do for the time being is to make a the report for all departments seperate in the cache.

But if someone know how a sollution it would save me a lot of work. Now i need to do this for 1 report, but there will be more in the future.
612229
If you can always reproduce the bypassing of the cache then it would be great if you could open an SR on Metalink3. Also make sure that in your Answers request, the "Bypass Oracle BI Presentation Services Cache" checkbox is unchecked. A work around would be to tune the report to run within, say, 10 seconds so that even if a cache entry is not available that the report returns data quickly. Seeding cache is typically one of the last options in performance tuning.

Mike

http://www.biconsultinggroup.com
1 - 7
Locked Post
New comments cannot be posted to this locked post.