Cannot do dimension save using XDI

Post Reply
Eighty3
Posts: 5
Joined: Wed Dec 12, 2018 5:12 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Cannot do dimension save using XDI

Post by Eighty3 »

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?
Eighty3
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]

Post by Eighty3 »

Restart of TM1 server resolved the issue
:D
Post Reply