Vanilla Audit & Performance – Managing weight for requests (part 2)

Dear Readers,

Something usefull with Vanilla v4 is the possibility to manage weight for requests, and prevent the request to be issued against the database – based on predefined rules – if the weight exceed the predefined limit.

What is the interest ?

Using FreeWebReport, user are able to build complex report that contain crosstab elements and various grouping strategy. Some user need “assistance” when it comes to build complex reports, and sometimes, putting too many element in a report is not effecient. Purpose is to stop the request a user may raise before it goes to the database if Bi admin think the request is too heavy (simple example : too many tables in the sql statment).

How does it works ?

Each table in the Metadata document is set with a predefined weight. We all understand its not a database admin feature, but more a datawarehouse features : tables have different behaviour – fact tables, dimension tables, aggregate table – different number of records and different index strategy. – Using Enterprise Services, each group of the Vanilla Group Table is set with a global limit. – When a user run a request, the Vanilla platform calculate the sum of weight for all the tables included in the requests. If the sum is superior to the limit set to the group, the request is stopped and a message raised in the interface.

FreeMetadata – Setting Weight for Tables

Enterprise Services – Setting limit for Groups

This feature is very flexible, and allow you to set a strategy outside of the database landscape. This can be an explanation, as we will see in next post in another audit & control interface, why a request can’t run for a specific group

Have Fun !

Patrick

Advertisements

How to run Audit on requests with Vanilla (part 1)

Dear Readers,

Something interesting with a Bi platform is the presence of audit function to analysis the query issued through the platform (to any kind of destination, such as sql database, olap database …). This post is the first of a serie talking about Audit, Performancance Audit & Platform Management.

With Vanilla, using Enterprise Services (an Open Source … thanks to the French Government initiative !), you can easilly control the different requests issued – per report & per group of user – using the Audit Perspective. Usage is so easy : you select one or more reports from the repository treeview – zone 1 – and drag & drop those reports in zone 2. Then, you select the groups for which you want to audit the different request statment – in zone 3.

Zone 4 of the image is the result : you can easilly view for a specific report the differents statments per groups, then control your security policy, detect a mistake in your Metadata join strategy, or even seea “no statment issued” if the group is not allowed to issue the request that built the report.

Enterprise Services – Audit Perspective

As usual, we focus on making the life easier to Bi developer and Bi Admin, by providing tools that reduce the development, validation & production cycle

Have Fun !

Patrick