Search found 3316 matches
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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 ...
- 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...
- 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?!"
- 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...
- 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...
- Fri Nov 06, 2020 4:33 pm
- Forum: Bugs
- Topic: HierarchyDeleteAllElements doesn't work for Leaves hierarchy
- Replies: 1
- Views: 209
Re: HierarchyDeleteAllElements doesn't work for Leaves hierarchy
Looks like someone has already reported it!
https://www.ibm.com/support/pages/apar/PH31159
https://www.ibm.com/support/pages/apar/PH31159
- 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...
- 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 ...
- 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).
(and this is how I write my feeders).
- 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 -?
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.