TM1 Forum

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

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

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

Assuming you are using the Delete key, have you tried right-click and then choose Delete?

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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