TM1 Forum

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

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

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

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

Wim Gielis wrote: ↑Mon Oct 08, 2018 8:05 pm Good idea to use FormatDate and ParseDate ! I'm a fan of these.

Yes, I find them much quicker and easier to use than the regular TM1 time/date functions.

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

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

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

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

Attributes are not specific to hierarchies, but exist for the dimension and all hierarchies associated with that dimension.

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

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

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.

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

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

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

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

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.