Home Applications MDX Query Auditing Samples

MDX Query Auditing Samples

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
4.25
2 reviews
0
Awards
182
Views
12
IPM installs
0
2
Details
Releases
Reviews
Issues
Pull requests
Articles
Samples for auditing queries on IRIS BI cubes and analyzing audit data

What's new in this version

add description to module.xml and ZPM info to readme

CubeAuditing

Samples for auditing queries on IRIS BI cubes and analyzing audit data

Setup

  1. Import classes into the namespace where you want to audit BI query activity and compile them.
  2. Enable logging by running the following command in that namespace: do ##class(Sample.AuditQueryLog).Init(). This will set ^DeepSee.AuditQueryCode so that Sample.AuditQueryLog:InsertQuery() will run (and create a new Sample.AuditQueryLog record) each time an MDX query is run in this namespace.
  3. Register AuditQueryLogCube in the Cube Registry for the namespace, schedule build and synchronize tasks as appropriate, and build it once from the Cube Registry (it may not yet have any data, unless you first run an MDX query).

ZPM Setup

Run zpm "install CubeAuditing" from a Terminal session in the namespace where you want to install the samples. Then proceed to step 3 of the setup instructions above.

Background

For more information on monitoring queries on IRIS BI cubes and cleaning up unused cubes based on this monitoring, see this InterSystems Developer Community article.

Read more
Made with
Install
zpm install CubeAuditing download archive
Version
0.1.418 May, 2021
Category
Analytics
Works with
InterSystems IRIS BI
First published
06 May, 2021