Have you ever wanted to change (or delete) a dimension, but first wanted to know how this action will impact your model? IBM Planning Analytics Workspace (PAW) allows you to quickly identify all the cubes in a database that include a specific dimension.
Since this is a development task, this approach is defined within a modeling workbench. You can access this option by right-clicking anywhere you see a dimension name within the databases tree (cubes, dimensions, control cubes, and control dimensions) and selecting the option to “View related cubes.”
The resulting list will define the full dimension name (e.g., not the caption) and show all the cubes that include the selected dimension.
If you want to better understand the data in the cube, you can then review any of them by clicking on the cube name and then selecting the option to Open the cubes. An exploration view for each cube will open on separate tabs in the modeling workbench.
This approach will give you a fast way to determine the overall impact of a dimension change.
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: Asymmetrical Expand in PAW
IBM Planning Analytics Tips & Tricks: PAW Greenbar
IBM Planning Analytics Tips and Tricks: Excel’s ARRAYTOTEXT Function
