Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Essbase 9 Implementation Guide- P76:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | Advanced Techniques One of the single largest users of system memory is the database outline itself. By its very nature the larger the outline the more server memory is consumed just to load the database into memory. We highly advise using extreme care in determining the data elements and data categories you will use for your database outline. Fewer dimensions are always preferable to more dimensions. For every new dimension in the outline the potential size of the data and the actual size of the outline grow exponentially. It is always better to have fewer dimensions with lots of members than it is to have more dimensions with less members. Think about it essbase.cfg memory settings Let s now take a look at those essbase.cfg memory specific settings that will directly affect the performance of your Essbase system multiplebitmapmemcheck Tells analytic services to enforce the size limit for the amount of memory that is used for the calculator cache when analytic services selects the multiple bitmap cache option. vlbreport Tells Essbase to dynamically determine the retrieval buffer size between 100KB and 10MB for retrievals from databases without Dynamic Calc Attribute or Dynamic Time Series members. This memory is only used when needed so it does not take away from continuous system resource availability. trigmaxmemsize This setting tells Essbase how much memory it can use to perform the trigger function. While the triggering function is a great feature it can be very memory intensive at the expense of other system operations. This memory is reserved by the application that has the trigger set up and is no longer available to the rest of the server. ssprocrowlimit Controls the maximum number of spreadsheet rows analytic services processes on an individual user spreadsheet request from Microsoft Excel. The default is 250 000 which is extraordinarily high for a spreadsheet request. You do not want a spreadsheet retrieval slowing down your entire server so we recommend
