TM1 Forum

You are misunderstanding what the HierarchySortOrder function is for! This is a new function introduced with v11 and alternate hierarchies . It performs the identical function for an alternate hierarchy as DimensionSortOrder does for a dimension (well actually for the same named hierarchy ) and you ...

Have noticed this too. It seems the SQLAPI logger got a little too "verbose". I think this might be a bug and also might have already been patched in a fix pack. See this https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/c_paw_nfg_enhanced_error_logging...

This is one area where IBM appears to have learned nothing from the shortcomings of TM1 Web. Basically all of the "legacy issues" of building and maintaining applications in TM1 Web are still there in Workspace. - you design a "menu" using buttons. A module or book gets added/deleted/name changed. Y...

this will also work DType( 'dim:hier', sElement) or in terms of varialbled you might have DType( sDim |':'| sHier, sElement ) Note the single quotes around the dimension name : hierarchy name. ALL the new hierarchy functions are nothing more than routing shortcuts to the existing functions passing t...

Do you have a direct line to Stuart King on this issue? I can't fathom why IBM seems to insist that this is a "non-issue". When a TM1 cube is the datasource for a TI process you need 100% consistent order of variable assignment ( and that order should match the index order of the dimensions in the c...

2) When executing RunTI in multiple sessions concurrently to process data in multiple threads, some connections to TM1 server fail in some of the parallel threads. (CAM authentication). RunProcess sometimes helps on this, but cannot not always replace RunTI. Actually this is a really key point that...

If you have a metadata/data section, it will skip only a single record and process the rest. So it's a good idea to place a ProcessQuit function in the metadata and data sections. Well actually there's a much better approach. In the condition where you ItemReject just convert the process on the fly...

The overhead of creating and destroying the view might exceed the time needed to loop and do a CellPutS on every element if the dimension is really small. My you're up early. Yep. That is indeed my experience. Quite often looping (or even nested looping) without the benefit of zero supression is ac...

Looks like the ideal thread for Lotsaram to respond ;) A little bit late to the party on this one. I think mce has actually hit on most of the key points already and doen a good job of summarizing. I have a few customers with systems in the several hundred GB to just over 1 TB territory. Typically ...

Many ways to skin a cat. Or loop through all products in the Prolog tab and set the status to empty or "Inactive" with AttrPutS function. Then in the Data tab set status "Active" with AttrPutS. This way you can be sure that only products present in the file will have status "Active". ( Note: this is...

I think the answer is "not really". As far as the server is concerned it is all Rest API and all treated equally. In the http header you can include client information for the session. This is useful in monitoring to identify that a session is PAW, vs Arc, tm1Py, Apliqo UX, etc. In theory you could ...

I am mostly interested in the multi-threading aspect while reading the data. I believe multi-threading basically involves setting the different config paramters in the tm1s.cfg file. As you mentioned, TM1 process may not trigger MTQ in every case. My confusion is around the same thing. How do I for...

Yes. The fact that the security model (users and groups) for PAW is disconnected from the TM1 server is absolutely a case of "what the h3ll were they thinking?!"

You can use MTQ=ALL or MTQ=-1 ... to utilise all processors Or if you want to be conservative and always leave 1 processor free for the OS to do other stuff MTQ=-2 ... to utilise all available processors less one Unless you have a hulking monster server with 96 or more processors then I would always...

As long as you respect the json format of the cell annotation cube you can create comments with TI process. You can even create the }CellAnotations_ cube on the fly with TI and it works fine. We have developed some solutions where an allocation process also automatically creates comments so that the...

Looks like someone has already reported it!
https://www.ibm.com/support/pages/apar/PH31159

It just came to my attention in TM1 server 11.8.00000.33 that HierarchyDeleteAllElements('dimName','Leaves') doess not actually delete any leaf elements! You get the same result using DimensionDeleteAllElements('dimName:Leaves') I haven't ever noticed this behaviour and it seems like a pretty seriou...

As an immediate (and/or long term) using a reverse proxy such as SweetSSL or NGINX is the best way to go to ensure that all content is secure and on the same domain. All the recent chromium based browsers enforce by default that to display content sites must include “SameSite=None; Secure” in their ...

I agree. If you have a reproducible test case then raise as a defect. There's no way this shouldn't work for MTFeeders.
(and this is how I write my feeders).

declanr wrote: ↑

Mon Oct 26, 2020 8:09 am

In that example it uses a comma for thousand separator, encloses negatives in brackets and does not show decimals.

Strictly speaking it doesn't enforce using comma as the thousand separator. Whatever the local regional settings are on the user's desktop for thousand separator will be substituted.