TM1 Forum

I HAVE A UNIQUE REQUIREMENT. NOT SURE IF IT IS POSSIBLE IN TM1


WE HAVE A COMMENT COLUMNS THAT IS DEPENDENT ON QUANTITY AND CODE
CUSTOMER CODE QUANTITY COMMENTS DATE A NOT GOOOD 0 CREATE STO 1/1/16 A GOOD 10 - 1/2/16


WHEN DATE IS 1/3/16 AND IF THE QUANTITY FALLS AGAIN TO ZERO FOR THE SAME CUSTOMER 'A' , WHAT EVER THE COMMENTS THAT HE PUT FOR CODE "NOT GOOD" WHICH IS "CREATE STO" SHOULD COME UP.


COMMENTS ARE NOT STATIC . USERS ENTER THOSE ON FLY DEPENDING ON THE CODE.


EVERY TIME THE LAST SUBMITTED COMMENT FOR THE COMBINATION OF THE CUSTOMER AND CODE SHOULD COME.

PLEASE LET ME KNOW IF IT POSSIBLE .

All caps? Really?

It depends on how this data is loaded as to how you resolve it but pretty much everything is possible in TM1.

I would guess based on the info that you have provided - the data is loaded once a month; so in february the system would load the quantity with a good/not good flag against a customer and month dimension for Januarys data - the user then enters the comments. Come to March the data is loaded for Feb and it starts again.
If this is the case the data load process can just loop back within the TM1 cube for the last time there was a quantity and the flag was the same; it would then do a cellgets and cellputs in to the current month as a starting point; the user could then change the comment if they want.

Where it would get trickier but far from impossible is if all the data (quantities) are loaded in one go... for example if it was for a budget etc but it doesn't sound like thats what you are doing.