Search found 23 matches
- Tue Aug 08, 2017 7:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX in ActiveForm with "INSTR" does not work
- Replies: 11
- Views: 13189
Re: MDX in ActiveForm with "INSTR" does not work
Thank you all for this great discussion on this unlisted, but unofficially available INSTR MDX function in TM1! A special thanks to SummerBrewGal for her post about using the optional fourth "language compatibility" parameter. Your post sent me down the path to explore this option which ul...
- Tue Oct 18, 2016 12:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form TM1RPTVIEW and DBRW Problem
- Replies: 21
- Views: 24648
Re: Active Form TM1RPTVIEW and DBRW Problem
Thanks for the question babytiger. I have a DBR formula which pulls the current "system date" from a control cube. This "system date" identifies the latest month of actual data loaded into the server. All of the other DBR formulas pulling data from the primary data cube reference...
- Fri Oct 14, 2016 4:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form TM1RPTVIEW and DBRW Problem
- Replies: 21
- Views: 24648
Re: Active Form TM1RPTVIEW and DBRW Problem
OK. Virtually all of the info in this thread I know and follow. Here's my challenge under v10.2.2 FP4: When attempting to convert the DBRW formulas to DBR (due to dependencies on other DBR formulas), the Active Form will continue to work with just one DBRW formula. Once the last one is deleted, the ...
- Mon Feb 15, 2016 9:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Date Error it shows 12/31/99
- Replies: 7
- Views: 4706
Re: TM1 Date Error it shows 12/31/99
Assuming you are using the Delete key, have you tried right-click and then choose Delete?
- Tue Jan 05, 2016 1:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Check for Source File Lock
- Replies: 3
- Views: 3292
Re: Check for Source File Lock
Another possible optionif you wish to keep it simple: Have the process which is sending the GL data file via FTP to the share also create a "flag file". This file would be a second and separate file name which is generated immediately after completing the FTP of the GL file. The Flag File ...
- Wed Jan 29, 2014 1:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1top issue
- Replies: 4
- Views: 4413
Re: TM1top issue
lotsaram wrote: "Or you can copy the tm1top.exe together with the ini file, the DLLs and the SSL folder out of C:\Program Files..." I am in the process of installing TM1Top (v10.1) onto the desktops of several key users. My question: must I copy the entire directory of DLL and SSL files? ...
- Mon May 13, 2013 11:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Automatically Expand Active Form Two Levels
- Replies: 11
- Views: 10721
Re: Automatically Expand Active Form Two Levels
Declanr is correct. You can also take this one step further by placing the MDX expression in a dynamic subset and then simply refer to the dynamic subset in the Active Form. The benefit of this approach is that the subset is exposed in the system and available to other views as a "single versio...
- Wed Nov 14, 2012 1:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ProcessError TI function doesn't work as expected
- Replies: 4
- Views: 4682
Re: ProcessError TI function doesn't work as expected
Thank you to all three of you for your responses! :) lotsaram, Thanks for linking to the other discussion which I did not find. It appears that Paul Simon is recommending what Alan Kirk calls option (b). While this does work, in this case, I am processing 10's to 100's of millions of cells and want ...
- Tue Nov 13, 2012 1:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ProcessError TI function doesn't work as expected
- Replies: 4
- Views: 4682
ProcessError TI function doesn't work as expected
I have the following code in the Prolog for parameter input verification: IF ( DIMIX ( Dim, vVersion ) = 0 ) ; sMessage = 'Version ( ' | vVersion | ' ) does not exist.' ; ItemReject ( sMessage ) ; ProcessError ; ENDIF ; As expected, the message appears in the message log. However, the process does n...
- Fri Mar 23, 2012 3:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How can I create TI Script with intangible element?
- Replies: 11
- Views: 8634
Re: How can I create TI Script with intangible element?
Great quality discussion here guys! I just joined this portion of the forum and recognize that this thread is a bit old at this point. However, for future readers, i would like to offer some additional thoughts... Assuming an internally generated index is needed, here are two other approaches to con...
- Wed Mar 21, 2012 3:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Disable Spread Method functionality
- Replies: 6
- Views: 6536
Re: Disable Spread Method functionality
Hi Chris, After re-reading your question are you saying you want to disable the right-click spreading menu itself? (which I don't think is possible) Or that you think there is a bug with Contributor not respecting element security when spreading? Assuming its the later: Have you double-checked the ...
- Wed Mar 21, 2012 3:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Disable Spread Method functionality
- Replies: 6
- Views: 6536
Re: Disable Spread Method functionality
I know this sounds like a lot of work, but is it feasible for you to have the normal hierarchy (up which natural consolidation takes place) hidden and then have a visible matching hierarchy for which the values are specified by a rule pulling from the corresponding hidden items. The spreading menu ...
- Tue Mar 20, 2012 9:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Disable Spread Method functionality
- Replies: 6
- Views: 6536
Re: Disable Spread Method functionality
Thanks Tomok. I looked in both pmpsvc_config.xml (doc in pmpsvc_config.xsd) and the Ops manual Chapter 2: TM1 System, Parameters in the Tm1s.cfg file (TM1 v9.5.2 SP1). The closest I come is the Spreading Precision parameter. Good idea, its just not there as an exposed control can that I can find. If...
- Tue Mar 20, 2012 6:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Disable Spread Method functionality
- Replies: 6
- Views: 6536
Disable Spread Method functionality
I have a client who is using TM1 Contributor for data entry purposes, but does not want to allow the user to spread data down a dimension hierarchy from a Total to the base (level 0) elements. I have attempted to use element security to give the user READ access at the Total level. However, this doe...
- Fri Jan 20, 2012 5:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Entry in TM1 Contributor 9.5.2
- Replies: 1
- Views: 2057
Data Entry in TM1 Contributor 9.5.2
Is there a way to allow data entry into a string cell at a consolidated level after the node has been submitted, without having to reject down to the leaf level and take ownership?
- Fri Jan 20, 2012 3:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Contributor View Column Header Width
- Replies: 2
- Views: 2733
Re: TM1 Contributor View Column Header Width
There is if you're on 9.5.2...add or modify this line in your Web.Config file: <add key="CubeviewerStringWrap" value="Enabled=true;MinCharactersToWrap=20;MaxDisplayCharacters=200;WidthOfWrapCell=50" /> Yes, I am using 9.5.2. I too saw this parameter. At your suggestion, I have s...
- Thu Jan 19, 2012 8:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Contributor View Column Header Width
- Replies: 2
- Views: 2733
TM1 Contributor View Column Header Width
I have several column names in a view that can be as long as 57 characters. However, it is a numeric element with a format mask of b:0.000;(0.000) F|3|Y with an input value restricted to < 1 and > 0. Currently the column header takes a single line. This causes each column to display very wide for su...
- Thu Jan 05, 2012 4:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Validation in TM1 Contributor
- Replies: 4
- Views: 5201
Re: Data Validation in TM1 Contributor
Thanks for your response lotsaram! I had thought of the validation measure to display a message based on a rule. This may be the route I go as it seems to be a "Best Practice". I hope IBM adds validation capabilities in the next release. As for my poor request on text field requirements, h...
- Wed Jan 04, 2012 10:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Validation in TM1 Contributor
- Replies: 4
- Views: 5201
Data Validation in TM1 Contributor
Happy New Year! :-) I am looking for a way to validate data input in TM1 Contributor. Example: A user enters a numeric value into a field. The value is only allowed to be in the range of 0.000 to 1.000 inclusive. Is there a way to do this? Also, I need to place requirements on a text field if anothe...
- Thu Dec 22, 2011 9:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Convert TM1 Contributor StateChangeDate to a formatted date
- Replies: 13
- Views: 12763
Re: Convert TM1 Contributor StateChangeDate to a formatted d
Michel and Skinners666, Thank you both! I have received some additional feedback from Jeff Allen, an IBM Solutions Specialist. He indicates this is a UNIX based date (java must use the same base). As such, he shares the same base formula this way when using Excel where H7 contains the 13 digit UNIX/...