TM1 Forum

Hi Has anyone (not as an admin user) uploaded data from csv files using a TI process over TM1 Web, over the internet? We are looking at using TM1 Web as a possible method to upload data to TM1 from users located around the world not on our LAN. One possible pitfall I can foresee is that the TI proce...

We have recently upgraded to 9.5.1 from 9.1.3 using the same excel files as applications and websheets on a new build but same configuration (32 bit web server - virtual & physical 64 bit data server). We have encountered 2 issues regarding to exporting, they may be related, they may be independ...

We have been running savedataall as a chore twice a day for years. Each data save has until recently taken seconds to complete. Now each data save takes between 2000 & 4000 seconds according to the message logs and consequently causes TM1 to be locked up for our users for 30 mins to an hour at a...

Thank you for all of your help. I finally ended up with a working solution: Attribute_Name = pRegion; Fund_Name = pFund; SubsetCreatebyMDX(pName,Expand('{FILTER ({FILTER( {TM1SUBSETALL( [Cap_Ref] )}, [Cap_Ref].[Region] = "%Attribute_Name%")}, [Cap_Ref].[Fund_Code] = "%Fund_Name%"...

I have created a dynamic subset in subset editor by recording the expression and filtering on one attribute and then another, so copied it over to TI... SubsetCreatebyMDX(pRegName,'{FILTER ({FILTER( {TM1SUBSETALL( [Cap_Ref] )}, [Cap_Ref].[Region] = "%Attribute_Name%")}, [Cap_Ref].[Fund_Cod...

I have managed to create a dynamic subset by MDX based on one attribute. Is it possible to create a subset based on more than one attribute? Is it as simple as using "And"/"Or" ???

many thanks.

I know TM1 & strings don't really mix, but when dealing with capital projects, there's a fair amount of static data i.e. as description, location, etc etc. So in setting up a capital project cost cube, I've decided to split out the strings and put them into a separate cube with 2 dimensions (pro...

Thank you very much.

I am new to TI so thank you in advance for your help... We predominantly use TM1 Web for our international users. I would like the users to be able to add a new element to a dimension by clicking an action button in a websheet, after they have inserted into a cell the element name. I have read the T...