Find unused dimensions

Ever wondered which of the dimensions in your TM1 Model are not used in cubes?

TM1py can help to answer this questions with 8 Lines of code!

If you have previously downloaded all samples folder, the script “find unused dimensions.py” is located in the Other folder:

If you want to only download this script, you can find the code on github.

Before running the script you should make sure that the connection with your TM1 instance is working:

• Check Connectivity with TM1

Open the python script with a text editor and update the TM1 connection information (address, port, user, password, ssl):

Open a command line from where the script is located and then type:

• python “find unused dimensions.py”

By default it is going to print the list of all dimensions in the command line.

To print this list of dimension in a file you can replace the following code:

    print(unused_dimensions)

with

with open('output.csv','w') as file:    for dim in unused_dimensions:        print(dim, file=file)

Your code should look like this:

Save the script and if you run the same command line again:

The script will create the file in the same location where the script is located:

Open the file and you will see the list of all dimensions:

This script will give you the list of all dimensions which are not used in a cube. But unused in a cube does not mean that the dimension is not used by something else. For example the dimension could be used in a TM1 process or TM1 rule.

To find all unused dimensions using a TM1 process, you can find the steps in this IBM guide:

• Find unused dimensions with TM1 process