TM1 Forum

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: 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

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 ?

Wim Gielis wrote: ↑Fri Mar 04, 2022 10:45 pm 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

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.

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

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