Dimension Hierarchy Files in TM1Data Folder

[ardi]

Hi,

We have a TM1 Model where we have created Multiple Hierarchies for some of the dimensions, and it looks like TM1 creates multiple files for each hierarchy in TM1Data folder.
So for example, I have created hierarchy calle "By Location" for Customer dimension, and TM1 has created multiple files HierarchyName.dim.YYYYMMDDhhmmss

Look the screenshot below:

TM1 Hierarchies.PNG (132.49 KiB) Viewed 1168 times

The version of TM1 we have is 2.9.0.2 (Build Number 11.8.00100.13)

DO you know if there is any config setting so TM1 does not create these files everytime dimension is updated?

Thanks

[Wim Gielis]

Hello,

I don't see that behaviour in a more recent version, 2.0.9.9. Your version is 1 year older than that version.

Are the files part of the data directory or a subfolder ?

What happens in the chore (I assume) that operates on those hierarchies, around 9.35 PM each day ?

[ardi]

Hello,

I don't see that behaviour in a more recent version, 2.0.9.9. Your version is 1 year older than that version.

Are the files part of the data directory or a subfolder ?

What happens in the chore (I assume) that operates on those hierarchies, around 9.35 PM each day ?

The files are on the root of TM1 Data Folder (same folder where cub and dim files are stored)
Yes there is a chore that updates dimensions and their related hierarchies.

Basically: For each dimension, the same pattern applies:

1. Unwind Dimension
2. Load DImension from a SQL Database

3. For each Hierarchy of the DImension.
3.1 Unwind Hierarchy
3.2 Load Hierarchy

Thank you

[Wim Gielis]

Do you have a more recent version at your disposal for testing ?

As indicated, I don't see the same files. Do you maybe use a function to delete all elements (or is the unwind the classic one with loops over parents and children) ? I'm just guessing this could perhaps trigger such a file.

[ardi]

It looks like this is caused by Audit Logging, we have Audit Logging turned on, and every time the dimension is updated, it throws the errors below:

18756 [] ERROR 2022-03-01 22:09:12.586 TM1.Audit.PostProcessor Error copying By Location.dim
18756 [] ERROR 2022-03-01 22:09:12.586 TM1.Audit.PostProcessor Error copying By Category.dim
18756 [] ERROR 2022-03-01 22:09:12.594 TM1.Audit.PostProcessor Error copying By Type.dim

Looks like I have to develop a process to delete these files

[Wim Gielis]

Good catch. Audit logging is not something I often use, so it did not ring a bell.