Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
No Cache hit

629048
Member Posts: 20
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
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
Answers
-
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/ -
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 -
Are you using any variables in your queries?
Mike
[http://www.biconsultinggroup.com]
-
Hi Mike,
no there are no variables used in the query. The only thing is that there are column with a formula.
regards,
Osman -
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 -
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. -
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
This discussion has been closed.