Search found 3658 matches
- Wed Jan 13, 2021 5:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL query works in SQL server but not in TM1
- Replies: 3
- Views: 87
Re: SQL query works in SQL server but not in TM1
You are also probably right that it is probably an authentication issue - unfortunately there is limited knowledge about TM1 within our company. Just to be clearer about that... I'm talking about SQL Server authentication, not TM1 Authentication. TM1 authentication regulates access to TM1 objects o...
- Wed Jan 13, 2021 3:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL query works in SQL server but not in TM1
- Replies: 3
- Views: 87
Re: SQL query works in SQL server but not in TM1
Broadly the query is Select A.VAR1, B.VAR2, C.VAR3, D.VAR4 from DB1 A, DB2 B, DB3 C, DB4 D Where A.VAR5 = B.VAR6 AND B.VAR7 = C.VAR7 AND B.VAR7 = D.VAR7 IF I remove the D.VAR4 from the above query there is no problem (ie if I open the same process delete D.VAR4 ,then save, all is well). The entire ...
- Thu Jan 07, 2021 7:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW on Windows server 2019
- Replies: 4
- Views: 188
Re: PAW on Windows server 2019
Have not seen anything confirming PAW on Server 2019, only articles saying it is not like this one. Oh silly me. Now I realise the error of my ways. Here I was thinking that I would be on safe ground trying to get the goddamn abomination called PAW to run on a Windows Server 2019 environment since ...
- Thu Jan 07, 2021 7:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: I'm trying to receive todays month
- Replies: 1
- Views: 90
Re: I'm trying to receive todays month
Hey , so I need to create a rolling average for the past 3 months. I am trying to get the current month (In dimension as 'mmm YYYY' for example 'Jan 2021' I Am Using this sCurrentMonth = ATTRS(sDim, (TIMST('\M') | (SUBST(TODAY(1), 1, 4))), 'PriorPeriod'); The (TIMST('\M') | (SUBST(TODAY(1), 1, 4)))...
- Sat Dec 26, 2020 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Question about the dependency between Metadata and Data
- Replies: 3
- Views: 340
Re: Question about the dependency between Metadata and Data
Hello everyone, I am new to TM1, I am testing the dependency between Metadata and Data. As I set up two new TI, one only with Metadata, and one only with Data. There is nothing to be gained by doing that. The Metadata and Data tabs are designed to work together hand in hand. These are the roles of ...
- Wed Dec 23, 2020 2:14 am
- Forum: General
- Topic: For anyone who has been depressed by the train wreck that was 2020...
- Replies: 4
- Views: 342
For anyone who has been depressed by the train wreck that was 2020...
... I offer this message of hope. In two days, now that UTC has ticked over, it will be Christmas day across the world. Granted, with lockdowns many families won't be able to get together the way they usually do, though for some families that may be a positive rather than a negative since virtual eg...
- Wed Dec 23, 2020 2:06 am
- Forum: General
- Topic: 75,000 posts
- Replies: 6
- Views: 790
Re: 75,000 posts
Well 75,001 now! :D It's good to see someone noticing. The reality is that it's a recognition of all the time and assistance that so many people, both past and present, have invested here over the years. I know that some people who work with TM1( :roll: ) considered milestone recognition to be "pos...
- Thu Dec 17, 2020 10:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Fix Pack Releases: PA2 / V11 Series
- Replies: 19
- Views: 23603
Re: Fix Pack Releases: PA2 / V11 Series
In case anyone missed this : A defect had been identified in the IBM Planning Analytics 2.0.9.4 release that can prevent the ViewZeroOut TurboIntegrator function from working correctly. No error message is provided to indicate the ViewZeroOut function or the TurboIntegrator process has failed. The r...
- Wed Dec 09, 2020 10:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Will IBM ever convert Perspectives to use the Rest API?
- Replies: 6
- Views: 412
Re: Will IBM ever convert Perspectives to use the Rest API?
TLDR: Not a chance in Hades. Perspectives assumes a LAN where a small request can be immediately acted upon. The feedback from the response to your chat can be used to better direct your query. Citrix allows this behaviour to occur over a WAN by transmitting the display only, like the terminals in t...
- Wed Nov 25, 2020 6:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Workspace - what can it do?
- Replies: 12
- Views: 609
Re: PA Workspace - what can it do?
Hi, Good shout on the error message luzig2019, hadn't picked this up. It seems like barely anyone noticed this new feature :lol: Should I make a topic about this on the "Useful code, tips and tricks" section? I don't think you can; IIRC posting rights in that forum require at least MVP rank. But if...
- Wed Nov 25, 2020 6:56 am
- Forum: General
- Topic: Elite Dangerous - Currently Free
- Replies: 1
- Views: 321
Re: Elite Dangerous - Currently Free
I'm not affiliated with the game in anyway but am a big fan. Just though I'd let the group know that the game is currently free in the Epic Game store if you fancy some space action. For those who have... issues... about the thought of dealing with Epic it's also steeply discounted on Steam, though...
- Sat Nov 21, 2020 5:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Re: TM1 9.4.1 Server Errors
- Replies: 2
- Views: 287
Re: TM1 9.4.1 Server Errors
We Have installed TM1 9.4.1 on Windows XP and Windows machine. The Server and client are installed on the same machine We getting the error below: 1. TM1.COMM.SSL error connecting to remote machine 2. Server cannot listen on port 5000 Can anyone who has dealt with the errors above assist? I am faci...
- Sat Nov 07, 2020 12:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What is the TM1 element member name maximum size limitation?
- Replies: 5
- Views: 3154
Re: What is the TM1 element member name maximum size limitation?
Interesting to know and thanks for the code. After testing, if wants the element to display properly in Architect, then nMax = 43679 is the limit. Otherwise, it will show empty element name with numeric icon at the first but definitely the element exists and is valid. In PAW, the limit goes above t...
- Fri Nov 06, 2020 8:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: JAVA Extension
- Replies: 9
- Views: 2399
Re: JAVA Extension
Not that you guys aren't raising valid points... but you do realise that you're replying to a thread that is one and a half years old and to members who haven't logged on for about 4 months? Unlike some unnamed sites, we don't have any rules about "necro"ing old threads... but I'm not sure that thes...
- Wed Oct 21, 2020 8:47 pm
- Forum: General
- Topic: Office 2010 EOL, in case anyone missed the memo...
- Replies: 1
- Views: 331
Office 2010 EOL, in case anyone missed the memo...
Support for 2010 is gone, dead, not pining for the fjords, etc. That also includes security updates: Support for Office 2010 ended on October 13, 2020 and there will be no extension and no extended security updates. All of your Office 2010 apps will continue to function. However, you could expose yo...
- Sun Oct 04, 2020 7:37 pm
- Forum: Bugs
- Topic: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash
- Replies: 8
- Views: 12544
Re: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash
I am developing TM1 models for the last 13 years (if we wait 4 days). I have never ever used dimension worksheets, rules sheets, TI code sheets or whatever they would be called, in Excel. They aren't called anything. As far as I'm aware there has never been an Excel-based process for generating TI ...
- Fri Sep 18, 2020 1:49 am
- Forum: Enhancements
- Topic: DBS should fail, hard!
- Replies: 9
- Views: 1518
Re: DBS should fail, hard!
So, here's the response to this one: PA for Excel will degrade dbs* to a read in all cases for consistency. ... Sigh. What can you say? To me this has all the hallmarks of someone who has never used the product operationally. Ooooh kay, this is what I posted as a comment, which will probably have n...
- Thu Sep 17, 2020 11:14 pm
- Forum: Enhancements
- Topic: DBS should fail, hard!
- Replies: 9
- Views: 1518
Re: DBS should fail, hard!
So, here's the response to this one: PA for Excel will degrade dbs* to a read in all cases for consistency. Perspectives itself was not consistent in the implementation across these functions as in 2/3 operational cases it would degrade to a read, while 1/3 would degrade to fail. part of the discrim...
- Thu Sep 17, 2020 4:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Extract Cube data into csv file using TI process
- Replies: 3
- Views: 517
Re: How to Extract Cube data into csv file using TI process
I'm still new to TM1 and I need help to extract data from a cube and save it as csv using TI process. I would recommend investing in some training. I'm not having a go at you in saying that but this is TM1 101, so if you can't do this you're really going to struggle. There are a lot of consultants ...
- Wed Sep 16, 2020 7:03 pm
- Forum: Enhancements
- Topic: Transfer of data between servers
- Replies: 9
- Views: 1423
Re: Transfer of data between servers
At least this one has also now moved to the "Future Consideration" pile.