Search found 3658 matches

by Alan Kirk
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...
by Alan Kirk
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 ...
by Alan Kirk
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 ...
by Alan Kirk
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)))...
by Alan Kirk
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 ...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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 ...
by Alan Kirk
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...
by Alan Kirk
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...
by Alan Kirk
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 ...
by Alan Kirk
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.