TM1 Forum

My rule is as follows: ['dimTier':'Non Tier Item', 'dimCSRPeriod':'07 CTD'] = N: IF(DB('cbmCSRWBS', !dimProject, !dimCSRWBS, '07', !dimYear) = 0, ['dimTier':'Non Cost Centre Item', 'dimCSRPeriod':'07 CTD'], IF(ATTRS('dimCSRWBS', !dimCSRWBS, 'Dummy') @= 'True' , -[ ELPAR('dimCSRWBS', 'A.10 Dummy',1) ...

Hi, Whilst that works for a single time dimension, I have 2 dimensions representing time, a year {2009,2010,..., 2020}, and a period {01,02,...,12} and need to accumulate from Jan 2009 to Dec 2020. The way I'm thinking of approaching this problem is to use a business rule to say that cum period 01 f...

I want to dynamically decide what account in my CoA dimension I need to post to depending on the project: Table (derived from TM1 subset): Project Type Attribute Project1 External Project2 Internal ... ... Slice: Project CoA Data Project1 Sales External 10.3 The project dimension should have subsets...

Does anyone know how to spool a tm1 subset to Excel along with the attributes belonging to that subset? I cannot use activeforms for the task in mind, instead having to manipulate a slice using VBA. I couldn't seem to find a worksheet function (or method in VBA) that allows you to do the above. Any ...

Thanks again for your help. The report just shows zeros when total programmes child is selected in the rngProjectsInput range. Is there a way to use the dbrw() function without having the row and column elements 'rebuild' themselves every time the report is refreshed (alt-f9)? ie. a static report in...

Thanks for your help but I don't think I've explained myself properly. External Opening Order Book Read from cube (Total Programmes - Consolidation) External Order Book Adjustments Write to cube (Total Programmes Child - Node) External Order Intake(+ive) Read from cube (Total Programmes - Consolidat...

Hello, I am trying to create an active form with one dimension (Orders) as my row, with a Projects dimension hidden above (for arguments sake I only have 1 measure): Orders Actuals External Opening Order Book (N) 150 External Order Book Adjustments (N) -10 External Order Intake(+ive) (N) 50 External...