Slightly harsh, Jim. If we were talking about arc or pulse then fair enough, but tm1py seems to me to be the epitome of open source and non-commercial.
Regards
Search found 298 matches
- Mon Feb 01, 2021 8:48 pm
- Forum: Free And Open Source Tools
- Topic: TM1py 1.6
- Replies: 9
- Views: 51121
- Fri Dec 11, 2020 9:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy/Paste in PAfE - Excel Not Responding
- Replies: 11
- Views: 5328
Re: Copy/Paste in PAfE - Excel Not Responding
I'm on 5.6 and it seems fine. I'd recommend going to 5.6 or above - up to 5.5 there were also issues with the VBA calls.
- Thu Dec 10, 2020 2:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Will IBM ever convert Perspectives to use the Rest API?
- Replies: 6
- Views: 4890
Re: Will IBM ever convert Perspectives to use the Rest API?
I've not used PAW enough to form an opinion (like Alan I'm an Arc aficionado), but the bits of PAW that make it to PafE and PafE itself are being welcomed with open arms in my user community. Benefits include (the perception) of faster speed, only having to use the local install Excel rather than a ...
- Thu Dec 10, 2020 6:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy/Paste in PAfE - Excel Not Responding
- Replies: 11
- Views: 5328
Re: Copy/Paste in PAfE - Excel Not Responding
Hi Ajay,
I haven't used the Quebit tool, as we're on Cloud and last time I looked it wouldn't run on an automation user.
Regards
I haven't used the Quebit tool, as we're on Cloud and last time I looked it wouldn't run on an automation user.
Regards
- Wed Dec 09, 2020 9:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy/Paste in PAfE - Excel Not Responding
- Replies: 11
- Views: 5328
Re: Copy/Paste in PAfE - Excel Not Responding
If it's any consolation, we're just going through the same exercise, and 99 out 100 reports are OK - it tends to be the old and crufty ones that fall over in my experience. Having said that, you're correct they're not really the same animal - this is a useful bit from Qubit: https://blog.quebit.com/...
- Tue Dec 01, 2020 9:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Default view not picking up Default subset
- Replies: 4
- Views: 1872
Re: Default view not picking up Default subset
Does the user have a private default view? If so, this will take precedence.
- Wed Nov 04, 2020 3:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Clear sheet in PAFX
- Replies: 1
- Views: 1020
Re: Clear sheet in PAFX
Hi Wim,
Try using Snapshot, Sheet instead. This will clear TM1, er, PAfE formulas and retain Excel only ones.
Try using Snapshot, Sheet instead. This will clear TM1, er, PAfE formulas and retain Excel only ones.
- Tue Nov 03, 2020 7:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel VBA, PAFX: make a cell static
- Replies: 6
- Views: 2300
Re: Excel VBA, PAFX: make a cell static
This should work:
with alerts turned off. If you're on any version earlier than .56 then the alerts won't turn off. .56 and above and they will.
Code: Select all
Application.COMAddIns("CognosOffice12.Connect").Object.AutomationServer.Application("COR", "1.1").ClearSelection
- Wed Jul 15, 2020 12:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1ELLIST syntax to get alias
- Replies: 4
- Views: 2650
Re: TM1ELLIST syntax to get alias
I raised a ticket and IBM support say it's a bug, and one they're not going to fix. I've figured out a workaround, but it's -ah- disappointing that IBM shipped it with this error. (Although, just to reiterate: the function works, it just won't return an alias against subset members.)
- Wed Jul 15, 2020 9:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1ELLIST syntax to get alias
- Replies: 4
- Views: 2650
Re: TM1ELLIST syntax to get alias
PAX is 11.0.54.6, PAW is 2.0.53 and PA is 11.6, but I've tested it on PA 11.7 and I'm still just getting the base element back.
- Tue Jul 14, 2020 8:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1ELLIST syntax to get alias
- Replies: 4
- Views: 2650
TM1ELLIST syntax to get alias
I'm have a senior moment trying to get this to work. I can get the array back, but I want to use a different alias. This just returns the base name, and I can't figure out why. =TM1ELLIST("JCG:COMPANY","Data Expected",,"Number and Name") where Number and Name is the ali...
- Wed Jul 08, 2020 8:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adobe Flash Player phase out issue
- Replies: 3
- Views: 2196
Re: Adobe Flash Player phase out issue
I'm going to go with "No".
- Thu Jul 02, 2020 5:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX API - error when calling macro
- Replies: 1
- Views: 1522
Re: PAX API - error when calling macro
This looks like a Windows issue, rather than an api issue, see https://www.tm1forum.com/viewtopic.php?f=3&t=14157
- Fri Jun 19, 2020 2:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Free Server Monitoring Tool other than TM1Top
- Replies: 4
- Views: 2836
Re: Free Server Monitoring Tool other than TM1Top
I can recommend Pulse from Cubewise, but it's not free (as noted above).
- Fri Jun 12, 2020 8:06 am
- Forum: General
- Topic: Good Morning!
- Replies: 2
- Views: 40907
Re: Good Morning!
Morning, Steve.
- Tue May 12, 2020 11:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing TM1 database assets with Git
- Replies: 12
- Views: 11340
Re: Managing TM1 database assets with Git
You could do a lot worse than start here: https://ykud.com/blog/cognos/tm1-cognos ... tm1-part-1
- Mon Apr 27, 2020 9:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Execute Bedrock TI in Perspectives
- Replies: 3
- Views: 1686
Re: Execute Bedrock TI in Perspectives
Or you could write a TI with the same parameters as the Bedrock process you want to run, with an ExecuteProcess to the Bedrock TI.
- Fri Apr 24, 2020 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model restarting for no apparent reason
- Replies: 3
- Views: 2637
Re: Tm1 Model restarting for no apparent reason
Short answer: yes. You will need to either reduce the size of the model or increase your RAM.
- Tue Apr 21, 2020 5:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to automatically extract TM1 reports in TM1 web using VBA?
- Replies: 1
- Views: 1408
Re: Is it possible to automatically extract TM1 reports in TM1 web using VBA?
TM1 Web doesn't support VBA - the documentation is reasonably clear about this.
- Mon Jan 27, 2020 1:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBR/DBRW formulas resulting in #VALUE! errors
- Replies: 8
- Views: 5857
Re: DBR/DBRW formulas resulting in #VALUE! errors
Try unticking the Transition formula evaluation box.