TM1 Forum

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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