This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

No Cache hit

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
Tagged:

Answers

  • 628531
    628531 Member Posts: 1,293
    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
    629048 Member Posts: 20
    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
    612229 Member Posts: 9

    Are you using any variables in your queries?

    Mike

    [http://www.biconsultinggroup.com]

  • 629048
    629048 Member Posts: 20
    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
    612229 Member Posts: 9
    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
    629048 Member Posts: 20
    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
    612229 Member Posts: 9
    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.