Hyperion Essbase (MOSC)

MOSC Banner

How to reconfigure Essbase database to avoid error 1012700

edited Aug 6, 2014 5:00AM in Hyperion Essbase (MOSC) 8 commentsAnswered


Hello.

I have an Essbase BSO database that is growing in usage, so I am concerned with fine-tuning the cube to keep the size down and performance fast.  The specifics/settings on the database are:

  • Buffer size 100 kb
  • 5 dimensions - 2 Dense and 3 sparse.  The Dense dimensions are the Accounts and Time dimensions.
  • Block Size is 715008 B; seems very large but is due to there being almost 4,000 accounts.  Potential # of Blocks is 198,900.
  • Index Cache = 10,240
  • Data File Cache = 500,000
  • Data Cache = 500,000
  • Storage is Buffered I/O

So what I've been trying is making a copy of the application, changing the Time dimension to Sparse, then stopping and starting the application.  When I attempt to retrieve from Excel I always get the error: "Dynamic calc processor cannot allocate more than [200] blocks from the heap.  Please increase CalcLockBlock setting and retry".  This message corresponds to error 1012700.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center