You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Low hit ratio on Data Cache

edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

Low hit ratio on Data Cache

Content

I have a BSO cube which has a hit ratio of 0.02 right now. Yesterday it was 0.16. I'm not sure what has caused the hit ratio to drop so much in just one day.

Here are the statistics:

I know that the block size is bit too much and it will affect the hit ratio on cache. But just in one day hit ratio has dropped more than 10 % which makes me think there is something wrong with the cube other than the block size.

Can anyone please explain what the problem could be?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!