TM1 Forum

Try using Application.EnableEvents = False before modifying the cell formula. Then .Dirty method on the range. Then trigger calculation. Thanks William. I was able to get it to work by doing this. Specifically, with the add-in loaded I was able to disable events once at the beginning of the routine...

I should also say that Sendkeys("F2") appears to work, again with the add-in active. However I have experienced crashes, though not as severe as using .dirty

In your VBA code, could you not set the cells you are updating to Dirty using the .Dirty method? This should force a recalculation of the cells next time the sheet is calculated. George, that worked (Sort of). What I have found is that PAfE has to be loaded but no connection /login is necessary for...

I have a problem which is not strictly a PAfE issue but I know some here are still into VBA I am using the following to repoint the cube source of the formulae c.Formula = Replace(c.Formula, "$B$1", "'XX'!$B$1") It updates the forumla fine but the revised formula does not work un...

There is a setting where locking is reported in TM1Server.log. This is a good place to start to gain insight. I used RunProcess in the same manner in my prior role and had a lot of problems with locking. When these specific locks were encountered the parallel processes would go into serial mode. And...

We are in the process of upgrading from 2.0.9.1 (tm1s.exe 11.8.00000.33) to 2.0.9.15 (tm1s.exe 11.8.01700.1) Start with this and change your plans: https://www.ibm.com/support/pages/node/6856457 In terms of your questions I recall there were changes around .12 or .13 regarding text file loads and u...

What you are looking for is something IBM has talked about doing for a long time, but I don't see it on the roadmap. https://bigblue.aha.io/published/30f7b700d5eb7d18cfdd19c793f4a10d?page=4 Basically it would be an extension of synchronisation where the target set MDX is dynamically driven by the s...

As a example I have a simple PAW Book with 1 View, I have dragged out 2 dimensions for user to filter the view. 1. Dimension is "Container Size" 2. is "Destination" I want the Destination subset to only show the destinations which have data for that Container Size. I'm reduced t...

- finding function that recreates hierarchy by attribute that don't require using HierarchyDestroy before (using CreateHierarchyByAttribute without using HierarchyDestroy before returns error) I see CreateHierarchyByAttribute as just a way of simple introduction to building hierarchies. It's very l...

I've already answered my question.

I had this setting in my config.

SQLRowsetSize=100000

When I comment it out everything is ok. Looks like a bug there.

I have raised this with IBM Support but thought I would ask if anyone has seen this. We have an ODBC query against a PostgreSQL materialised view which returns 72,000 rows. Using ODBC in Excel all rows come through fine. In a TI any rows past 65536(2^16) have string values set to null and numeric va...

the other which bugs as soon as I put myself on totals for the dimensions You need to be much clearer and detailed if you are seeking help. eg: 1) Does the dynamic report return the expected data when you REBUILD with the workbook open 2) Do you receive any error messages 3) How have you constructe...

So DBRW will not work with TM1Set if the TM1Set references another hierarchy? Maren No, different functions are required for cell read and cell send etc. IBM showed DQR and some of the new worksheet functions almost 3 years ago when the release of DQR was then imminent. I think Cubewise have built ...

Of course we all want the new hierarchy data functions but I don't see anything in the roadmap for that. My understanding is that the TM1SET function does this, though I have never used it so I may be wrong. I was waiting for the arrival of Universal Reports to start playing with TM1SET. Maren Univ...

Now released in PAfE 2.0.90 I'm expecting everyone will be looking at it soon enough, I'm thinking it might warrant an ongoing thread Seems to have a lot of functionality and I don't want to be negative but some of the omissions are a bit problematic. I'm assuming they will be resolved in further re...

I lead a server rename several years ago and 2 of us co-wrote something to rename all references to the server and all buttons (And there was something specific to do tithTM1User() worksheet function). It all worked fine. Here is the specific subroutine which did the name change. I don't think we ne...

With UseExcelSerialDate=T in the cfg file I wrote the following back in 2018 as part of an orchestration TI.

s_Weekdays = 'SunMonTueWedThuFriSat';
n_Weekday = 0;
s_Dayname = '';

n_Weekday = Mod( DayNo( Today) -1 ,7);
s_DayName = Subst(s_Weekdays,(n_Weekday * 3)+1,3);

I expect that this is to be the length of a piece of string. Just wondering if there are any general recommendations issued, I could not find anything. We are about to deploy changes which will result in a step increase in RAM usage and we have a handle on the expected increase from our Dev instance...

Yes it's a Planning Analytics question. We only have CA for single signon on premise and it was configured by a group we are no longer working with. Our environment AD functional support is being upgraded by IT. I am asking this question from a position of complete ignorance on AD setup etc. Before ...

Wasn't there a post the other day about some additional variables available for use with RunProcess? I searched but have not found it. You may be referring to my earlier post in this thread. The NEW PA engine (What was to be Server 12) has some useful new functions to handle communication between t...