Search found 97 matches
- Tue May 07, 2024 7:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Universal reports
- Replies: 7
- Views: 2584
Re: Universal reports
Hi guys, Is anyone aware of any utility that can help to migrate perspective reports to Universal Reports? Even if it does only half of the work, it will still be helpful We have lots of websheets with Active Forms which are really dynamic, so I know there will be impossible to find a utility that ...
- Thu Apr 04, 2024 12:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA Replace to alter DBRW references in PAfE
- Replies: 7
- Views: 2003
Re: Using VBA Replace to alter DBRW references in PAfE
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...
- Tue Apr 02, 2024 11:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA Replace to alter DBRW references in PAfE
- Replies: 7
- Views: 2003
Re: Using VBA Replace to alter DBRW references in PAfE
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
- Tue Apr 02, 2024 11:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA Replace to alter DBRW references in PAfE
- Replies: 7
- Views: 2003
Re: Using VBA Replace to alter DBRW references in PAfE
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...
- Tue Apr 02, 2024 3:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA Replace to alter DBRW references in PAfE
- Replies: 7
- Views: 2003
Using VBA Replace to alter DBRW references in PAfE
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...
- Tue Mar 26, 2024 4:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to avoid queuing at the end of processes parallelization ?
- Replies: 5
- Views: 2705
Re: How to avoid queuing at the end of processes parallelization ?
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...
- Wed Nov 15, 2023 4:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance drop between 2.0.9.1 and 2.0.9.15
- Replies: 7
- Views: 10092
Re: Performance drop between 2.0.9.1 and 2.0.9.15
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...
- Wed Nov 01, 2023 4:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW How to make View Filters work together
- Replies: 9
- Views: 9275
Re: PAW How to make View Filters work together
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...
- Mon Oct 23, 2023 7:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW How to make View Filters work together
- Replies: 9
- Views: 9275
Re: PAW How to make View Filters work together
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...
- Mon Oct 23, 2023 5:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Recreating Hierarchy by Attribute
- Replies: 2
- Views: 2767
Re: Recreating Hierarchy by Attribute
- 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...
- Fri Oct 20, 2023 5:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with ODBC connections, rows past line 65536 nulled/zeroed
- Replies: 1
- Views: 2549
Re: Issue with ODBC connections, rows past line 65536 nulled/zeroed
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 had this setting in my config.
SQLRowsetSize=100000
When I comment it out everything is ok. Looks like a bug there.
- Fri Oct 20, 2023 5:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with ODBC connections, rows past line 65536 nulled/zeroed
- Replies: 1
- Views: 2549
Issue with ODBC connections, rows past line 65536 nulled/zeroed
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...
- Mon Oct 02, 2023 2:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: configuration for Planning Analytics For Excel
- Replies: 2
- Views: 2508
Re: configuration for Planning Analytics For Excel
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...
- Thu Sep 14, 2023 11:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Universal reports
- Replies: 7
- Views: 2584
Re: Universal reports
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 ...
- Wed Sep 13, 2023 11:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Universal reports
- Replies: 7
- Views: 2584
Re: Universal reports
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...
- Wed Sep 13, 2023 7:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Universal reports
- Replies: 7
- Views: 2584
Universal reports
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...
- Mon Sep 11, 2023 1:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - VBA to Change Server Name
- Replies: 6
- Views: 772
Re: Action Buttons - VBA to Change Server Name
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...
- Mon Sep 11, 2023 12:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1s.cfg parameter to have Excel serial dates
- Replies: 3
- Views: 672
Re: TM1s.cfg parameter to have Excel serial dates
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);
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);
- Thu Aug 31, 2023 10:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Any recommendations on available RAM
- Replies: 1
- Views: 544
Any recommendations on available RAM
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...
- Wed Jul 19, 2023 6:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Directory functional level support with CA 11.2.2
- Replies: 0
- Views: 11641
Active Directory functional level support with CA 11.2.2
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 ...