MDX Query Auditing Samples

Downloads8
Subscribe
0
Bookmark
2
This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
Details
Releases
Reviews
Issues
Videos
Articles

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.

ZPM installation
zpm "install CubeAuditing"
Rating
3.5 (1)
Category
Analytics
Works with
InterSystems IRIS BI
Tags
Info
Version
0.1.4
Last updated
2021-05-18
Repository
Open
Documentation
Open
License
Link