Vanilla Audit & Performance – Hypervision Features (Part 3)

Dear Reader,

Last post of a serie about Auditing Vanilla Requests, using Hypervision to analyse FreeMetadata requests and Mdx Requests sent to UnitedOlap engine (by the way, I will post later on Vanilla Platform process Audit)

After connecting to your Vanilla server with Hypervision, you have the following interface where you have specific PlugIn to analyse your performance

Hypervision interface

Running the FreeMetadata Requests Analysis (item 1) will display this interface – with a filter on date to reduce the number of entries – where you can view the convert sql statment issued against the database (understanding the document is based on a Metadata datasource).

You can even detect some errors in the generated sql statment : this can occurs when you burst a report with groups that are not allowed on the document, when you have an issue in your filter strategy (you forget to set a where clause) or if your database has changed and a column is not available anymore). For each item, you can view which group ran the request and how much times it took to get the result from database.

FreeMetadata Requests Analysis


The second interface (item 2 from main Hypervision interface) is about UnitedOlap requests performance. A simple screenshot is worth than thousand words : you can select your cube, and from the cube you can view the most popular requests and see the response time evolution (outside cache strategy)

UnitedOlap Requests Analysis

Running analysis makes sense only if you can manage the potential issues. Using the Vanilla Admin interface, Bi developer and Admin person can enhance the Metadata document to improve sql statment, modify some join path with additional aggregate tables or even play with the cache manager to pre-cache the most popular dataset or datagrid.

Vanilla Analysis features is a must, look around in your commercial experience … and think about a move to Vanilla, its time now !

Have Fun !