TM1 Forum

NB: Not sure whether that works in Web, though... (It doesn't in my test environment but that's all on one Windows 7 machine rather than running on a real server. The manual is silent on this subject.) I tested this out recently through a server running CX10.1 and although it allowed me to select u...

http://www.tm1forum.com/viewtopic.php?f=3&t=8501&p=38263#p38263 So you haven't explicitly said in either this post or the one above how you worked out that your websheet issues are stemming from the IRR and NPV calculations but I suppose it safe to assume that you did trial and error in the ...

At the risk of repeating myself, let me repeat. The dimension you are writing the DIMIX statement against HAS TO EXIST IN THE CUBE STRUCTURE. Using a picklist does not mean it is part of the cube structure. When you click on the plus sign next to the cube and expand the dimension list, is Cargos on...

sPar = 'A';
sCh = 'A2';

iCount = 1;
iMax = ElCompN ( sDim, sPar );

While ( iCount <= iMax );
sEl = ElComp ( sDim, sPar, iCount );
If ( sEl @= sCh );
sOrder = iCount;
iCount = iMax;
EndIf;
iCount = iCount + 1;
End;

Hi JDLove and Garry, Sorry for taking long to reply to you guys due to unfortunate accident. Thanks for pointing out the mistake. I have been doing some test and managed to load data into the cube by the multiline dimension elements. However, when my country is a dimension the data in first country...

After reading the subsequent posts I got intrigued and tested this myself. Although I definitely remember experiencing the DIMIX and DIMNM failing on }processes dimension at some point a few years ago. I just tried to recreate in V10.1 and it works perfectly fine in both the TI formula and the Excel...

Jim, I have also come across this in the past and (although I didn't dig into it) I just assumed it to be standard for all } objects. It was the same for DIMNM and DIMIX. To get around it I just had a TI run every night that created a duplicate of the }dimension and named it zProcesses etc. Cheers, ...

['Actual','Z'] = IF ( (['X'] - ['Y']) >= 0, 2, IF ( (['X'] - ['Y']) >= -0.05, 1, -1) ); I am using this one to feed it but looks like cube is still not fed correctly. The result in cube is right by the way. ['Actual','X']=> ['Z']; ['Actual','X']=> ['Z']; I presume the above is a typo and you actual...

Seriously? 2.5?

Is there absolutely no chance of you being able to upgrade your version of tm1? Keeping in mind we are into the 10's.

Change the "UseBookRecalcSetting" parameter in the web.config file to true and TM1Web will take the calculation that each websheet is saved with in excel as its standard when first opened.

Hi, I have a cube that have 4 dimensions: Year, Month, Jobs, Jobsinfo. Jobsinfo has a start date (string). How do I make this string date appear at consolidated level? When I change the month to Q1, all the jobs are listed, but with a blank start date. Any ideas? In order to show a C-level string e...

Tim, I have also noticed this, it seems that when IBM released the newest version they have made some fundamental changes and not documented it... completely unlike IBM I know... Anyway I seemed to be able to bring it back into line by manually making sure that the VMM / VMT values in }CubePropertie...

Hi Nessie, Probably the easiest way would be to change the formula to reference a Dynamic Subset CURRENT EXAMPLE: STATIC SUBSET =TM1RPTROW($B$9,"Production:PJ_Dim","",'{AR}01'!$B$16:$B$23,"PJ_Dim & Description",0) Note: PJ_Dim is the name of the dimension. REVISED ...

Have you actually gone to the error log by navigating to the folder which contains them or have you double clicked on the error pop up screen that appears after the TI? If it is the latter and you haven't properly closed the window before running the TI again, it can appear as if its opening the new...

Hi all, Does anyone know a way of displaying an on-screen error message when validating parameters in TI? I have a process which takes Year/Month/Ledger parameters into a data load, and I am using ITEMREJECT to validate the user input. This writes a message to the logfile but i'd like to be able to...

Either change it so its unique (e.g. v4 | ' - ' | v5 ) or looking at that file possibly just insert v5 straight under v3 and stick v4 in as an attribute. Without knowing your account structure I can't really say what is the correct thing to do but your TI is doing exactly what you are telling it to....

I think you'd be better off applying a rule (or using a TI possibly scheduled by a chore) to update an }elementsecurity cube. Just keep in mind that if you go down the route of using rules you will need to look into using securityrefresh in a TI or something. Updating the }elementsecurity cube does...

I think you'd be better off applying a rule (or using a TI possibly scheduled by a chore) to update an }elementsecurity cube.

Just keep in mind that if you go down the route of using rules you will need to look into using securityrefresh in a TI or something.

Assuming you have your year as a dimension you can just apply TM1 security against the element dimensions.

Hello, I have a question regarding the use of ItemSkip. I am using Itemskip in metadata tab. The Criteria is such that in the metadata tab, this is the code If (DIMIX('Customer', vCustomer)=0); ItemSkip; EndIf; In the data tab, I am using a cellputN function. But I am getting an error which says, t...