Search found 20 matches
- Thu Aug 05, 2021 10:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View to show first item in subset dynamically
- Replies: 12
- Views: 11525
Re: View to show first item in subset dynamically
If your dimension is in the context (or Title) area, you can use ViewTitleElementSet, no changes to the subset needed. https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=vmtf-viewtitleelementset ViewTitleElementSet(CubeName, ViewName, DimName, Index); A curious note to this function - if a s...
- Mon Jan 21, 2019 8:20 pm
- Forum: Commercial and Events
- Topic: TM1 coding extension for VSCode
- Replies: 13
- Views: 38974
Re: TM1 coding extension for VSCode
But I have a question. Is there a parameter or something in the tm1s.cfg that we can change to allow direct editing of the .RUX or .PRO files ? I doubt it very much. For me, what works best until now, is using AutoHotKey to have a hotkey (F10) copy the code of the selected tab and paste into Notepa...
- Fri Jan 18, 2019 3:25 pm
- Forum: Commercial and Events
- Topic: TM1 coding extension for VSCode
- Replies: 13
- Views: 38974
TM1 coding extension for VSCode
We just put out a free TM1 coding extension for VSCode (also free). I've been doing my TM1 coding in VSCode for several months now and I think it's a great environment and the extension makes it even better with syntax highlighting, code snippets, etc. Happy coding! https://marketplace.visualstudio....
- Tue Oct 09, 2018 4:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: When is a "hierarchy" not a hierarchy
- Replies: 10
- Views: 5850
Re: When is a "hierarchy" not a hierarchy
Dimension is still needed, not everything is a hierarchy. It's possible to have dimensions and no hierarchies, but you can't have hierarchies without dimensions. This is kinda the point. No it's not like that. In Planing Analytics all dimensions have hierarchies . You can't in fact have a dimension...
- Mon Oct 08, 2018 8:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting the last date of a month in TI
- Replies: 10
- Views: 8290
Re: Getting the last date of a month in TI
Yes, I find them much quicker and easier to use than the regular TM1 time/date functions.Wim Gielis wrote: ↑Mon Oct 08, 2018 8:05 pm Good idea to use FormatDate and ParseDate ! I'm a fan of these.
- Mon Oct 08, 2018 6:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting the last date of a month in TI
- Replies: 10
- Views: 8290
Re: Getting the last date of a month in TI
Code: Select all
nSerialDate = ParseDate( sYear | '-' | sMonth | '-01', 'yyyy-M-dd' );
nSerialDate = nSerialDate - 1;
sLastDayPriorMonth = FormatDate( nSerialDate, 'yyyy-MM-dd' );
- Mon Oct 08, 2018 5:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: When is a "hierarchy" not a hierarchy
- Replies: 10
- Views: 5850
Re: When is a "hierarchy" not a hierarchy
Dimension is still needed, not everything is a hierarchy. It's possible to have dimensions and no hierarchies, but you can't have hierarchies without dimensions.
- Mon Sep 24, 2018 5:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?
- Replies: 10
- Views: 7626
Re: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?
This is how conversion to static values is handled in the latest versions of PAx: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/c_cxr_gt_strtd_convertdatatostatic.html Also, both Quick Reports and Explorations can be opened, refreshed, and sent to us...
- Tue Sep 11, 2018 2:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy Attribute Functions
- Replies: 11
- Views: 5722
Re: Hierarchy Attribute Functions
To further clarify, you would add attributes to a dimension so that you can store attribute information about the elements within that dimension. To store attribute information about hierarchy names, you don't add attributes to dimension:hierarchy, you have to add them to the dimension that has dim...
- Mon Sep 10, 2018 8:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy Attribute Functions
- Replies: 11
- Views: 5722
Re: Hierarchy Attribute Functions
To further clarify, you would add attributes to a dimension so that you can store attribute information about the elements within that dimension. To store attribute information about hierarchy names, you don't add attributes to dimension:hierarchy, you have to add them to the dimension that has dime...
- Mon Sep 10, 2018 8:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy Attribute Functions
- Replies: 11
- Views: 5722
Re: Hierarchy Attribute Functions
AttrInsert adds an attribute to the dimension. Then, you would need to populate that attribute with a value for an element using AttrPutS or HierarchyAttrPutS. . Then, you could pull that attribute value using ATTRS or HierarchyATTRS. But, it sounds like you are actually trying to set up an alias fo...
- Mon Sep 10, 2018 7:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy Attribute Functions
- Replies: 11
- Views: 5722
Re: Hierarchy Attribute Functions
Attributes are not specific to hierarchies, but exist for the dimension and all hierarchies associated with that dimension.
- Tue Feb 27, 2018 5:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Not Responding/Hang Upon Editting Dimension and Element
- Replies: 1
- Views: 2012
Re: TM1 Not Responding/Hang Upon Editting Dimension and Element
That's called locking. A good way to gain visibility into locking is to set up tm1top. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_op.2.0.0.doc/c_understandingtm1lockmodes_n161413.html https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.b...
- Tue Feb 27, 2018 5:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Loading server with big-sized Cube and MaximumCubeLoadThreads
- Replies: 2
- Views: 2920
Re: Loading server with big-sized Cube and MaximumCubeLoadThreads
It seems IBM is still working through multi-threaded loading. As of PAL 2.0.3 multi-threaded loading has been disabled. https://community.watsonanalytics.com/discussions/questions/36249/mtcubeload-and-maximumcubeloadthreads.html Also, at some point MaximumCubeLoadThreads was replaced by MTCubeLoad. ...
- Thu May 11, 2017 8:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Top for Planning Analytics Local 2.0
- Replies: 4
- Views: 4610
Re: TM1Top for Planning Analytics Local 2.0
Yes, I'm using it in a couple of different PAL environments. It's officially included with the install and should only need to be configured. It is also covered in the PAL Ops Guide.
- Tue Jan 03, 2017 7:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 crash: deleting the subset that is the data source of a TI process
- Replies: 9
- Views: 5315
Re: TM1 crash: deleting the subset that is the data source of a TI process
IBM put a new "pull invalidation subsets" feature into 10.3 (cloud) and PA 2.0 that might be related. You could try adding PullInvalidationSubsets=F in your tm1s.cfg and see if that avoids the crash. Is this documented somewhere? Certainly isn't here: http://www.ibm.com/support/knowledgec...
- Tue Jan 20, 2015 4:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Renaming Xcelerator CXMD
- Replies: 1
- Views: 2133
Renaming Xcelerator CXMD
What do you think about renaming the ICAS (TM1) database that is named CXMD by default within Cognos Express? Will it break the connection to other components within Cognos Express? I don't see that IBM prohibits it, but I'm assuming they would strongly discourage it because of those connections to ...
- Fri Sep 19, 2014 7:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to set a filter on a string member?
- Replies: 10
- Views: 7551
Re: How to set a filter on a string member?
I'm surprised those 4 statements work, as you are not specifying members for all four dimensions. Keep in mind that the MDX you are writing is to create a subset within a single dimension. The MDX would look something like this for a given month: { Filter( {TM1FilterbyLevel( {TM1SubsetAll( [Staff] )...
- Mon Apr 22, 2013 9:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process locking cube from reading
- Replies: 16
- Views: 10835
Re: TI process locking cube from reading
With PI on lock are triggered by changing dimensions. This includes structure / elements and the bit that gets missed, attributes. (Not sure if it is all attributes or just alias, untested) I'm not aware of anything else that triggers locks, certainly all the standard data load stuff like building ...
- Wed Mar 07, 2012 10:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: New TM1 book
- Replies: 0
- Views: 1862
New TM1 book
IBM Cognos TM1 The Official Guide arrived in the mail today! I'm looking forward to reading through it to see what helpful nuggets I can gain.
There is a delightful Forward by Manny to get it started.
There is a delightful Forward by Manny to get it started.