Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
   Multi Layer Architecture Report Development for Enterprise Reporting  

ENCYCLOPEDIA→   Vendor- IT Tool Domain  →   -  BI End User Tools  →   -  Enterprise Reporting- Technical Features  → 

Load, Log and Cache Management for Reports

These are the server level administrative features on how an enterprise reporting tool manages the load, process logs and the cache.

Cluster aware

This is related to the level of flexibility, in terms of how a tool can be installed in a cluster. There are some tools, where any module can be installed in a server cluster (Crystal) OR where only one specific layer can be done. For a medium load application, this is not really a critical aspect, but for large scale implementations, it becomes important.

Enterprise Reporting Server Load Balancing

This is a bit self explanatory. A reporting tool has to have a good load balancing module which can manage the load on the servers related to various layers.

Cache

Should allow cache to be created by default. Cache is similar to ‘Cache’ files used by the internet explorer whereby it stores the files in the local hard-disk so that it does not have to go to the network every time it needs the same file. Similarly, the reports once generated are retained in the cache so that every time your need a report, you don’t have to process it again, and you can use the one existing in the cache. Some of the features are:

  • Cache should be able to switch off and on: This enables you to cache, when you want to do. For example, when you don’t want a report multiple time, you may not need cache the same. Caching with all its advantage do take disc space and some processing power.
  • The frequency of resetting the cache: This allows you to set the time over which the cache will be reset (deleted) for example, you may set-up the cache to be deleted after every 7 days, OR you could state the cache reset time for every different report.
  • Provide page by page cache: With this feature, you should be able to get the cache in small increments. For example, if I am accessing a report of 1000 pages from the cache, it allows me the retrieve it page by page (OR at group level- for example retrieve a sales report by location and not to get the whole report of hundreds of location in one go). This reduces the retrieval time and memory requirements.

Logging

  • Enterprise Reporting server execution log- This logs the programs OR objects executed by a server (Front-end layer server, process management layer server OR/and processing layer server)
  • Trace log for debugging- For specific debugging purpose, one should be able to turn on the trace log, which helps you to look at each function step execution.
  • Performance log- This the logs on how much time/resources were spent in completing the given number of tasks.
  • Report generation log- This is similar to the report server execution log, but limited to the reports and queries and is more end-user friendly. It logs the reports, when they were generated, their destination and formats etc.
 

   Multi Layer Architecture Report Development for Enterprise Reporting  
 
 

Was this page helpful?
 
 
More on Reporting- Technical Features
Multi Layer Architecture
Report Development for Enterprise Reporting
Report Delivery
enterprise Reporting Server connectivity
BUY BI & Data Management Vendors & Tools Evaluation Kit
Read more...
BUY largest on-line Data-Quality Management Kit
Read more...
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Leads Generation through advertising
Sales Channel Partner Acquisition
Sales strike rate
Enhancing Sales Channel productivity
Sales Leads Management SWOT
Read more...
  Customer Relationship Management
Drivers for Customer Satisfaction & Retention
Customer Value and Profitability-Overview
What is Customer Segmentation?
Customer Service and Support Overview
Customer Satisfaction and Retention- Overview
Read more...
  Human Resources & Leadership
Empower Front-line Employees
Fitting leadership dimension in employee performance
Lead diverse and collaborative teams
Business and Financial Acumen
Roles and Level based Competency Segregation
Read more...
 
 
Business Performance & Planning
Strategic Planning leadership commitment
Strategy Blueprint Information Gathering
Strategic Business Plan
Strategic Planning Business Themes
SWOT Assessment Report
Read more...
  Business Intelligence & Data Quality
Dimensional Model Schemas- Star, Snow-Flake
Performance Review not for action-status
BI Competency Centre- A preface
Data standards not only for IT
Business Intelligence Project Management Success Metrics
Read more...
  IT Vendors & Tools Management
OLAP Architecture Cache Management
Vendor Commercial Evaluation- Licensing IPR
Vendor Delivery Project Evaluation
OLAP Sever Database Tuning
Data Integration- Migration, Synch, Federation
Read more...