TM1 Forum

I have what should be a simple issue, but can't figure it out with cube rules or even TI, newbie here obviously :) I have an input cube tracking project hours by week. I need to move that data to a reporting cube. The issue is that the project in the input cube is a picklist item on the time dimensi...

Got the TextOutput part, just haven't figured out the "Placeholder" part

TextOutput('D:/filename.csv',SUBST(EmpName,1,long(EmpName)-7),RC,SUBST(SupName,1,long(SupName)-7));

I have a cube that has 3 dimension: EmpName, DeptNum, SupName. The values in EmpName are in the format Name - Employee Number (so as an example it might look like this Jones, Tom - 1234 (same with SupName). 2 records might look like this: "Jones, Tom - 1234","ABC123","Barker...

Thanks for the response. I knew I was going to get called out on the Year and Month-Yr dimensions :lol: . We'll either be removing the year dimension or modify the Month-Yr to be just Month Hadn't thought about the alias on the Month, I'll check that out. When I do any asciioutput I just see " ...

Hi, I'm trying to create a TI process that imports data from a text file, easy enough. The issue I'm having is that I need to transform one of the fields into 2, seperating the month from the year. I have this field vDate, sample value is 20160401121024. I need to transform that into the year '2016'...

Has anyone had any experience or tested TM1 with IE11. I don't see it on the supported list.