TM1 Forum

Thank you....!

Hi All I have a scenario in which i need to bring the name of the resource who is allocated for example i have 2 cubes Capture.PNG in the 1st cube there is an option for input, if we type 1 in front of Anne in allocated resource, then when we run the Ti Anne's name should appear in 2nd cube in the s...

Thanks Mark it worked

Hi Everyone, My scenario is I have A cube with 3 dimensions Days, Department & Measure. In measure i have 3 elements that are picklist by example Capture.PNG . I have a dimension in which there are opportunity 1 2 3 & 4 I need if i have selected a member in opportunity 1 from the picklist th...

Hi, I have tried to get a ratio for 1 particular job code, For e.g in cube 2 I have an annual salary of Alex as 50000 which is allocated along with 4 job codes lets say, Cube 1 Week1 = 5000 Week2 = 10000 Week3 = 10000 Week4 = 10000 Week5 = 15000 Cube 2 Amount Ratio JC1 = 10000 0.2 JC2 = 20000 0.4 JC...

I wanted a solution on how can I build the 3rd cube which would allocate the salary by job code by weekly. As I mentioned i don't have job code dimension in 1st cube & I don't have week i.e time dimension in 2nd cube. I want to allocate the salary by Job code & by the week in 3rd cube using ...

Hi EveryOne, I was going through a problem where I have 2 excel sheets, in 1st sheet I have Employee Salary on a weekly basis that would roll up to months & further to year, in 2nd sheet I have the same Employee salary according to there JobCode but on an annual basis. I have created 2 Cubes and...