TM1 Forum

thought this post would contain the solution to my problem... that wasn't the case... still found a solution...
For anyone having issues connecting Excel to TM1 via VBA, check out this: http://www-01.ibm.com/support/docview.w ... wg21959177

Hi all, it's been a while but this calc'ed vs stored/frozen data hasn't stopped bugging me - mainly b/c i want to create reports using DBRW() function. In the meantime i've learned though, why the reports i've created took sooooo long to refresh/recalculate. From my understanding the Excel TM1 add-i...

Hi... and a BIG thx! even the laymen understood... ;) one concern though... how to you deal with hierarchy changes in for instance the costcenter dimension? If it's policy to restate historical data to align with the new / current org structure would mean historic data would have to be re-calc'ed an...

unfortunately that's all i have on the cache... i'll try to poke and find out more and will share if there's any meat... reading again through Jim's post explaining what TM1's ASO and BSO is, can i in laymen's talk "put this into a nutshell" like this: ASO: aggregation rules aggregate leaf...

one thing that my BI folks told me: IBM is working on "In dex ed Caching" for the next version of TM1... supposedly that will resolve some of the issues/waiting I'm seeing... have you / has anyone heard of this?

Hi Jim, i'm not a TM1 admin... in an old role i wrote the specs for an Essbase planning application and had external implementers do the heavy lifting... i just reviewed, added some KPIs and made some small rules changes in Essbase's admin consol... now in a new role i'm working for the first time w...

hi Alan, thx so much for your answer and input - very helpful! to address some of your questions and give you a real look at what i was talking about i made screen capture of a sample Excel report - it's in Excel where i intend to pull data to then design reports... it's a 5 min video where you can ...

thx for the quick replies... are you confirming then, that extracting 1,000 data points from TM1 via DBRW should take maybe a few seconds instead of >10 minutes...? my fin. systems / BI folks are telling me that all is perfectly set up and that there is nothing that can be done... with the Essbase e...

Hi all, i'm new to TM1 and to this Forum so please bear with me... have a question about calculation and about retrieving data from historic periods & scenarios... I used to work with Essbase were i could easily retrieve (via ad-hoc or HsGetValue function) data at pretty much every level of a di...