Search found 3660 matches
- 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...
- 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...
- 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...
- 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 ...
- 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 ...
- 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)))...
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...