Dynamic report Rebuild Book - fails after disconnect / reconnect

Post Reply
jydell
Posts: 33
Joined: Fri Jul 09, 2010 12:12 am
OLAP Product: tm1
Version: TM1 Build Number: 11.8.01300.
Excel Version: Version 2401

Dynamic report Rebuild Book - fails after disconnect / reconnect

Post by jydell »

Hi

Wondering if anyone has seen and found a solution for this. After disconnecting and reconnecting within excel a dynamic reports rebuild book fails

Scenario
* Dynamic form in Excel (any cube any data - as long as its dynamic)
* Normal refresh / rebuild book works OK (under 1 second)
* Disconnect and re-connect from TM1 from Excel
* rebuild report - takes 5 mins (exactly 5 mins to refresh)

Practically this happens when people time out due to inactivity (and it is a nuisance), above is an easy way to replicate the issue.

Any solutions that anyone can offer. Increase the time out will hide the issue but create others.
Wim Gielis
MVP
Posts: 3203
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: Dynamic report Rebuild Book - fails after disconnect / reconnect

Post by Wim Gielis »

If you are on the latest versions, I think this is one for IBM Support.
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
Post Reply