TM1 Forum

Thanks again for all your help, I was just checking best practice.

Merry Christmas everyone!

Magnus

If you are suppressing all C levels, why are they there? We have dimensions that are shared across different cubes, in some of these cubes consolidations are needed (and hence feeders have been added). However in other cubes that also has the shared dimension, consolidation of the value does not ma...

Hi, Would just like to check with the community on the best practice for using Feeders. As I understand it, Feeders are used to optimise cube performance. You have to be aware not to underfeed feeders to ensure that the consolidated value is correct. Over feeding can greatly affect the performance o...

Thanks for clarifying

I changed it to this,
and it has worked. Not sure what is different other than swapping TM1SUBSETALL with TM1SubsetBasis.

Hi, I would like to create a dynamic subset by using a T.I. I understand that you need to use the function "subsetcreatebyMDX()" I currently have a dynamic subset for one my dimensions that was created by recording the expression within the subset editor, but when I use this expression as ...

Hi,

Are you able to post here the variable tab of your T.I. that may help people understand your T.I. a little better.

Sorry for the delay, My goal was to get TI to find a file (a file that I would not know the name of) upload the data from said .csv file, once data had been uploaded into a cube, move said .csv file then loop the process so it looks for the next file in the source folder, uploads the next .csv file,...

Hi,

Thanks for everyone's advice, this works fine now.

Have there been any details about TM1 10? Has IBM even mentioned the release of TM1 10 other than the planned release of the TM1 book? I'm only asking because a quick google search did not return much about TM1 10's release. It would be good to know what new features this release has to make it TM1 ...

Hi Gregor, Using the concat function just creates a new destination folder called [original destination]|[filename]. The robocopy /move also moves everything that is in the origin folder into the new folder (as the function doesn't see a source file to copy). I am also trying to get the batch file m...

Hi, Just a quick question regarding ExecuteCommand() TI function. I'm trying to move a file between one location to another. The function works perfectly when I type in the file in the source folder. I would like to add a variable to ExecuteCommand() function instead of the exact file name. To clari...

Hi,

Thanks for your advice and yes I think you understand my problem. Just going to try out what you said.

Regards,
Magnus

Hi All, I wish to update a Cube using data from a .CSV file via a T.I. process. The problem is is that I have two different sets of hierarchies. The dimension in the cube has a set of hierarchy ( Rail (Group) -> Rail, x train, y train ) Rail, x train and y train are child elements of Rail (Group). T...

Thank you

Hi, I understand the NumberToString / StringToNumber T.I. functions. Is there a way to do a NumberToString / StringToNumber function within the cube rules (and not using the T.I.). The reason for this is because I wish to be able to compare a number that is stored as a string to a number that is sto...

Hi, After a day of googling and receiving the help from here, I've finally solved my problem. Here is the code I am using. Sub CopyYtoAll() ' AutoUpload - CopyYtoAll ' 15-Sep-2011, Alan Kirk ' Example only; no error handling added. ' A reference must be set to TM1 Tools in Tools -> References... ' i...

I think you'd be far better off leveraging Excel's calculation muscle via inbuilt worksheet functions rather than trying to iterate through a range. At the risk of stealing Paul Nielsen's thunder (though he says it in the context of SQL Server)... you should always try to "kill the cursor"...

I'm very new to VBA and I'm having a bit trouble regarding where to put the bit of code you kindly posted. Do I write it above or below the Sub? Also if you could offer a bit more detailed advice about your code that would be great. Do I need to modify your code or can I just put it straight into th...

Thank you for your advice.

Regards,
Magnus