Page 1 of 1

Planning Analytics Model Explorer

Posted: Sat May 13, 2023 6:27 pm
by Gampy
Planning Analytics Model Explorer is a tool that helps quickly and visually get an idea of the structure and state of a model, identify potential problem areas, and optimize some of the routines that Analysts and Modelers often face in IBM Planning Analytics.

For Modelers and Analysts:
  • Conduct a quick audit of a new or legacy model and build a visual lineage between cubes and other system elements;
  • Find potential problem areas and bottlenecks among model objects;
  • Quickly retrieve data that may not be very convenient to obtain using standard IBM Planning Analytics (Cognos TM1) tools, for example: which cubes use one or another dimension, cubes sparsity, etc.;
  • Get quick visual information about security settings (for example, who has access to the selected cube and access level, or, conversely, which cubes the selected user has access to);
  • Identify the top cubes with the longest recalculation time (re-feed);
  • Receive visualized information about the size of cubes and their components, as well as changes in the amount of memory used over time.
For managers:
  • Monitor data about user activity during the working day on the dashboard;
  • Get a list of inactive accounts in order to optimize user licenses;
For users:
  • Get a visual representation of the model functional map;
  • 2. Evaluate source data necessary to generate the final reports of the model;
  • Search for changes in the Model by the new values and view data change in the transaction log using suitable aliases using;
  • Determine the Processes that change the data in the target cubes;
Project page.

Re: Planning Analytics Model Explorer

Posted: Sun Jan 12, 2025 10:37 am
by Gampy
The source code for the tool is now available in the GitHub repository. The link can be found on the project page in the previous post.