TM1 Forum

Hi Declan, There is a long list of generated statements of CellPutN, but left most of these out as I don't believe it is causing the problem. In the prolog tab: #****Begin: Generated Statements*** DIMENSIONSORTORDER('Shipment_Type','','','BYINPUT','ASCENDING'); DIMENSIONSORTORDER('Client_Code','',''...

Hi, Thank you for this. I thought I was on the right track, you clarified things for me. I still have one more problem if you could help please./ When the 1 is populated against each record it seems to apply the 1 to the record before. Eg 00001AE 0 when it should be 1. When I calculate the values fo...

Hi, Thanks for the reply and appreciate your help. I've put in the script as advised but how does it know to insert a 1 against each record in the measures dimension? In other words, the intersection of 0001AE, Department, Year, Month insert a 1 for each unque record... Does this make sense.. I thin...

Hi All, I was wondering if you could help me. As I'm importing the data, I would like to count the records and assign a '1' to each record. No Count Cumulative 0001AE 1 1 0002AE 1 2 0003AE 1 3 I need a TI formula so that as each new record is imported it assigns in the 'measures' dimension a '1' I'm...

Hi Andy,

Never mind I worked it out using your magical tip. Thank you so much for helping me out. It was driving me crazy.

I had to think of the problem a little differently and you guided me in the right area.

Once again thanks for your help. Really appreciate it.

Hi Andy,

Would I just create a text attribute and apply a 1,2,3 against the relvant names in column B?
is the formula =ATTRS(dimension, element, attribute)?

Thanks

Preview: Active Form Formatting Issue Hi All, Could someone please help me with my issue. I'm relatively new to Active forms and what works in Excel design does not necessarily work in TM1 web, making me want to tear my hair out . I have the format area in the active forms as: [Begin Format Range] C...