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 ticket Size Mix
Sales velocity (or speed of sales)
Sales Campaign Infrastructure
Sales Revenue SWOT
Sales Leads Generation through advertising
Read more...
  Customer Relationship Management
Customer Service and Support Overview
Customer Segmentation Actions
Exit barriers for Customer Retention
Customer Segmentation approach
Customer Value and Profitability- BI
Read more...
  Human Resources & Leadership
Give feedback closer to the observation
Strategic Business Plan
Lead diverse and collaborative teams
Develop Self and Others
Setting Strategic Intent and Alignment
Read more...
 
 
Business Performance & Planning
Strategy Map to Strategic theme
A KPI should be simple -but it depends
SWOT Analysis in Strategic blueprint Planning
Scorecard Health Checklist
Strategic Planning leadership commitment
Read more...
  Business Intelligence & Data Quality
Metadata Architecture Design
De-normalized DW- Data Warehouse vs. Data mart
Data Warehouse BI Staging Area
Effectiveness of Data Stewardship
Lead Generation KPI for campaign
Read more...
  IT Vendors & Tools Management
Data Profiling and Monitoring
BI Tool Vendor Evaluation
Data explosion OLAP Server
Vendor Evaluation Conversion effort
Commercial & Contractual Matrix
Read more...