Search found 3316 matches

by lotsaram
Thu Jan 14, 2021 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySortOrder problem
Replies: 2
Views: 188

Re: HierarchySortOrder problem

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 ...
by lotsaram
Wed Jan 13, 2021 5:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.SQLAPI error message in TM1Server log
Replies: 4
Views: 141

Re: TM1.SQLAPI error message in TM1Server log

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...
by lotsaram
Wed Jan 13, 2021 5:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom PAW Menus
Replies: 2
Views: 121

Re: Custom PAW Menus

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...
by lotsaram
Mon Dec 14, 2020 10:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DTYPE for hierarchies?
Replies: 3
Views: 585

Re: DTYPE for hierarchies?

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...
by lotsaram
Wed Dec 09, 2020 9:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 13
Views: 4043

Re: Dimension Order in an MDX cube view as datasource

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...
by lotsaram
Mon Dec 07, 2020 11:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 12
Views: 665

Re: TM1 Servers with TBs of Memory

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...
by lotsaram
Mon Dec 07, 2020 8:49 am
Forum: Useful code, tips and tricks
Topic: Displaying custom error messages after running a process in PAW
Replies: 2
Views: 295

Re: Displaying custom error messages after running a process in PAW

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...
by lotsaram
Fri Dec 04, 2020 11:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding attributes only to newly created elements
Replies: 6
Views: 379

Re: Adding attributes only to newly created

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...
by lotsaram
Fri Dec 04, 2020 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 12
Views: 665

Re: TM1 Servers with TBs of Memory

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 ...
by lotsaram
Fri Dec 04, 2020 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding attributes only to newly created elements
Replies: 6
Views: 379

Re: Adding attributes only to newly created

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...
by lotsaram
Thu Dec 03, 2020 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Throttle and / or Block a users Rest API connection from third party apps.
Replies: 8
Views: 395

Re: Throttle and / or Block a users Rest API connection from third party apps.

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 ...
by lotsaram
Mon Nov 30, 2020 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multi threading in planning analytics
Replies: 4
Views: 373

Re: Multi threading in planning analytics

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...
by lotsaram
Thu Nov 26, 2020 6:39 pm
Forum: Enhancements
Topic: Creating Users of TM1 in PAW
Replies: 3
Views: 259

Re: Creating Users of TM1 in PAW

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?!"
by lotsaram
Thu Nov 12, 2020 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTQ
Replies: 4
Views: 685

Re: MTQ

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...
by lotsaram
Mon Nov 09, 2020 9:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Annotation Cube: Loading new records
Replies: 7
Views: 675

Re: Annotation Cube: Loading new records

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...
by lotsaram
Fri Nov 06, 2020 3:24 pm
Forum: Bugs
Topic: HierarchyDeleteAllElements doesn't work for Leaves hierarchy
Replies: 1
Views: 209

HierarchyDeleteAllElements doesn't work for Leaves hierarchy

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...
by lotsaram
Tue Nov 03, 2020 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2.2 to PA TM1Web iFrame Issue
Replies: 13
Views: 1609

Re: 10.2.2 to PA TM1Web iFrame Issue

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 ...
by lotsaram
Tue Nov 03, 2020 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with Feeder Processing in PA
Replies: 13
Views: 616

Re: Problem with Feeder Processing in PA

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).
by lotsaram
Mon Oct 26, 2020 10:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Number Format to Make Zeros display -?
Replies: 4
Views: 360

Re: Custom Number Format to Make Zeros display -?

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.