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
Dimension Hierarchy Files in TM1Data Folder
-
- Community Contributor
- Posts: 151
- Joined: Tue Apr 02, 2013 1:41 pm
- OLAP Product: tm1, cognos bi
- Version: from TM1 9.4 to PA 2.0.9.6
- Excel Version: 2010
- Location: Toronto, ON
Dimension Hierarchy Files in TM1Data Folder
Ardian Alikaj
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Dimension Hierarchy Files in TM1Data Folder
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 ?
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 ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Community Contributor
- Posts: 151
- Joined: Tue Apr 02, 2013 1:41 pm
- OLAP Product: tm1, cognos bi
- Version: from TM1 9.4 to PA 2.0.9.6
- Excel Version: 2010
- Location: Toronto, ON
Re: Dimension Hierarchy Files in TM1Data Folder
The files are on the root of TM1 Data Folder (same folder where cub and dim files are stored)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 ?
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
Ardian Alikaj
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Dimension Hierarchy Files in TM1Data Folder
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.
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.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Community Contributor
- Posts: 151
- Joined: Tue Apr 02, 2013 1:41 pm
- OLAP Product: tm1, cognos bi
- Version: from TM1 9.4 to PA 2.0.9.6
- Excel Version: 2010
- Location: Toronto, ON
Re: Dimension Hierarchy Files in TM1Data Folder
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
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
Ardian Alikaj
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Dimension Hierarchy Files in TM1Data Folder
Good catch. Audit logging is not something I often use, so it did not ring a bell.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly