Search found 19 matches

by ndivine
Mon Jan 21, 2019 8:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 coding extension for VSCode
Replies: 3
Views: 812

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...
by ndivine
Fri Jan 18, 2019 3:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 coding extension for VSCode
Replies: 3
Views: 812

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....
by ndivine
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: 801

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...
by ndivine
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: 944

Re: Getting the last date of a month in TI

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.
by ndivine
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: 944

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' );
    
by ndivine
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: 801

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.
by ndivine
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: 1884

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...
by ndivine
Tue Sep 11, 2018 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Attribute Functions
Replies: 11
Views: 658

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...
by ndivine
Mon Sep 10, 2018 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Attribute Functions
Replies: 11
Views: 658

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...
by ndivine
Mon Sep 10, 2018 8:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Attribute Functions
Replies: 11
Views: 658

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...
by ndivine
Mon Sep 10, 2018 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Attribute Functions
Replies: 11
Views: 658

Re: Hierarchy Attribute Functions

Attributes are not specific to hierarchies, but exist for the dimension and all hierarchies associated with that dimension.
by ndivine
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: 623

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...
by ndivine
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: 706

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. ...
by ndivine
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: 1647

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.
by ndivine
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: 1588

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/knowledgecenter/SSD2...
by ndivine
Tue Jan 20, 2015 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Renaming Xcelerator CXMD
Replies: 1
Views: 1016

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 ...
by ndivine
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: 2811

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] )...
by ndivine
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: 4529

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 ...
by ndivine
Wed Mar 07, 2012 10:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New TM1 book
Replies: 0
Views: 529

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.