Search found 3660 matches

by Alan Kirk
Wed Jan 20, 2021 11:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Dimensions Using Referentials .How does i work ?Where to learn about it
Replies: 9
Views: 168

Re: Creating Dimensions Using Referentials .How does i work ?Where to learn about it

Thank you So much Alan. This is very helpfull The naming 'Referentiel' is what is used in some companies. I think it is a key word used by clients so it became a norme I guess. Thank you Could it be that you're a French speaking person natively ? That's a really interesting point; though if that is...
by Alan Kirk
Wed Jan 20, 2021 9:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Dimensions Using Referentials .How does i work ?Where to learn about it
Replies: 9
Views: 168

Re: Creating Dimensions Using Referentials .How does i work ?Where to learn about it

I saw some people use referentials to create dimensions and it's elements. Basicaly from what I understood the referential is a worksheet where they declare the dimensions and its simple element , comsolidated elements,attributes ...etc. I would Like to know what is the steps we should follow to cr...
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: 114

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: 114

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: 240

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: 111

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: 364

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: 402

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: 829

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: 23695

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: 475

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: 664

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: 337

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: 313

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: 3207

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: 2477

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: 347

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: 12607

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: 1592

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: 1592

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...