No Cache hit

629048

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

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