Hello,
I have a TI process that creates a project dimension with more than 15 attributes. I need to update this dimension frequently and I saved the csv file on the server. It happened a lot that the TI process failed to recognize changes in the data, I tried to go to different data sources to force it to "wake up" but even that failed sometimes and I had to recreate the TI process. Can someone please help me resolve this?
thanks so much in advance.
Using TI to recreate a dimension changes not being picked up
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- gtonkin
- MVP
- Posts: 1261
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Using TI to recreate a dimension changes not being picked up
Please can you give some more context and information
- are you deleting elements or unwinding hierarchies?
- are you using the Direct commands in data or standard commands in Meta Data
- can you share code that shows us what you are doing?
- are you deleting elements or unwinding hierarchies?
- are you using the Direct commands in data or standard commands in Meta Data
- can you share code that shows us what you are doing?
-
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Using TI to recreate a dimension changes not being picked up
What you’re saying really doesn’t make sense. Any piece of code will do exactly what it has been programmed to do. So either there’s a mistake in your code, or the file isn’t being updated when you think it is or like you think it should have been, or the process isn’t running when you think it is.
Either way, unless you share the code no one can help you.
Either way, unless you share the code no one can help you.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Using TI to recreate a dimension changes not being picked up
Without seeing the code, it's impossible to solve the issue (if there is any issue).
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: Using TI to recreate a dimension changes not being picked up
I’m new to TM1, so I just manually setting up the dimension using TI, I can’t write codes directly. The problem occurs When I add a new attribute column to my CSV file, then go to data source, click on preview, the new attribute column doesn’t show up in the preview window, so it doesn’t translate into a variable on the variable tab.
The structure of the CSV is like this:
Project code Name address. Number of units. Type of service etc etc
I’ll post the codes when I get back to the office tomorrow, but looks to me that the TI process somehow didn’t recognize there is a new column in the CSV file.
Thanks so much for your reply!
The structure of the CSV is like this:
Project code Name address. Number of units. Type of service etc etc
I’ll post the codes when I get back to the office tomorrow, but looks to me that the TI process somehow didn’t recognize there is a new column in the CSV file.
Thanks so much for your reply!
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Using TI to recreate a dimension changes not being picked up
You need to alter the data source name (adding and removing a space is fine) such that the preview is recreated but more importantly, the Variables tab is updated. Like that your process and the wizard can be updated.
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: Using TI to recreate a dimension changes not being picked up
Thank you so much for your help! This forum is amazing!