Materialised Query – Basics and Reporting Performance
Use Sharperlight Materialised Query to improve Reporting Performance
by consolidating data into a Materialised Query. Data is read out of the live system and consolidated and stored in a Physical Table. Reports are then redirected to the Materialised Query therefore reducing the access time.
The example shows Excel with data extracted from the SAP Business One Transaction Table with Accounts on the Rows and Periods on the Columns
• Improve Reporting Performance
• Consolidate Data from multiple Sources
• Archive Data as Historical Snapshots
• Budgeting and Modeling
• Write back
• Warehousing
Please note
If you create a Materialised Query Databasse or Table while using Client Setup Local Connections then other users who are Remote Connecting to the Central Sharperlight App Server will not see the new Dbs, Tables or Fields. This is because you would be making changes outside of the App Server and therefore it does not know about these changes. To avoid this one should Remote Connect to the App Server and make the changes there so that everyone can see them. If changes are done outside of the Sharperlight App Server Service you will need to restart it so it can pickup the new changes.