Hi all,
I am new to TM1 (beginner) and the company I work at has run into issues with saving XDI (Dimension Save). The issue started last week when a user added a n-level element to the xdi worksheet and tried to save (Dimension Save). Excel just hangs and goes into not-responding mode for hours. The user is a experienced user and has been maintaining this xdi for years. I have looked at the log in procmon and I do not see anything unusual. I can see that a xid file is created on local PC and successfully copied to TM1 server and the thread is closed as per Procmon.
No changes have been made to this dimension via dimension editor.
I have following troubleshooting to resolve the issue so far with no luck and I get same behavior (Excel just hangs) when trying to do a Dimension save.
- Created a new XDI by exporting the dimension
- I have tried to restore the xdi file from previous working version (with and without the new record that was added)
- Copied the data from xdi to a new xdi file
- Tried on different PCs
Points to note
The xdi file we are trying to 'dimension save' has 20,000 rows
The same xdi file works flawlessly in UAT environment
Dimension save for other xdi file (20 records) works fine
Dimension save for other xdi file (18000 records) has same issue. Excel hangs
Any help would be much appreciated. Please let me know if additional information is required.
Would a server restart resolve the issue?
Cannot do dimension save using XDI
-
- Posts: 5
- Joined: Wed Dec 12, 2018 5:12 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Cannot do dimension save using XDI [RESOLVED]
Restart of TM1 server resolved the issue