TM1 Forum

Thanks Wim!, you are absolutely right loading the consol data in flat and bring it back in hier. Also I had a quick brainstrom session with business to understand the design that, there will not be any unallocated left in parent level, means whatever parent got everything will be distributed to thei...

Hi Everyone, I got a scenario where the budget values in the data file having some numbers against the parent as well, like below Data File.PNG If I skip the consolidation load, then cube default rollup is different then what it usually has, Cube Rollup.PNG so I have decided to roll up everything to...

Get it? Thanks lotsaram! now I get it, I'm pretty much close to the workaround to solve this issue. However I don't see why you need a new cube with a discrete time dimension. Is the account dimension the same? Is the basis of data storage the same or different (movement vs. balances)? Perhaps you ...

Hi David, Just curious about your suggestion on adding another time dim using rule/feeders to link, I haven't done this before. So just trying to understand here, Say for eg., existing system has a GL cube with below dims, Existing GL Year Month Cost Centre Account Scenario GL Measures New Design Ti...

Hi rmackenzie, Just realised, one of my scenario will not fit in for creating "opening balance" in all months YTDs, say for example in below scenario. I have to get cost to date(CTD) spent on 2012-08 YTD for calculating some interest, CTD.PNG So If I use Opening balance it gives me the bel...

You are legend!! I have created similar thing but haven't think to add this in '09 YTD' i.e all months YTD by default. Thanks a lot. Reason for not going to continuous time dimension, 1. The existing system already has discrete time dimensions as YEAR and MONTH, all cubes (including GL) has been loa...

Hi, I have a scenario where YTDs is not fitting in the existing time dimension(Discrete), say in my existing system has YEAR and MONTH dimension separately like below, Time Dim.PNG Now we got something to enhance by creating new cubes for cash flow, so only way is to stick with existing dimensions, ...

['roundup'] = - INT( - ['value'] );

That's Beauty!! Thanks Duncan P!! Working Good

['x'] = round(['y'] - ['z'] + 0.49999);

oh...that's Kewl one Martin!!! Let me give a try!

TM1 uses the Round down method of floor(x + .5)

You are right EvgenyT, Floor & Ceiling functions are Excel ones.

Thanks a lot EvgenyT & Martin!!

Thanks for your reply EvgenyT. 1. You are right I can easily get the months from both dates and subtract, but in worst case if the current month in Dec and my Completion month in March in that case i get x = 12 - 3 = 9, but I need 3. So I opt to go with DAYNO. 2. Bang! we both are in same page now. ...

Hi, In TM1 Rules, I'm subtracting two dates to get the remaining months to forecast, first converting the date into DAYNO then converting into months. In this case say for eg in excel. Today 21/08/2013 >> 41507 & Completion Date 1/10/2013 >> 41548 x = (41548 - 41507) = 41 days = 12*(41/365) = 1....

why don't you just run the server without the persistent feeders switched on in the first place?! Thanks lotsaram!! I changed the config file to switch off the persistent feeders. I hope this would resolve for next Monday. Instead of changing the config file, thought of deleting the feeders first a...

First of all thanks for your reply!!! It sounds like you really need to test if that is happening - is it in the chore where a process is throwing a circular reference error? It may be that you need to run a one-liner process with the DeleteAllPersistentFeeders command on its own rather than in anot...

Hi Experts, I have an issue in loading the TM1 server after the scheduled chore to restart TM1 server at 3AM, because of the below error server load failed. 3832 [] INFO 2013-03-17 16:10:24.770 TM1.Cube Loading body for cube }ElementAttributes_Group_Scorecard 3832 [] ERROR 2013-03-17 16:10:24.770 TM...

Kudos!!!, it works and very handy one for quick analysis.... Thanks Gareth!!!

Hi Gareth - Thanks for the spreadsheet!!! I'm getting an error while the macro trying to open the RUX files. I've connected as client machine, so path should be something like below, I guess its not the problem with path. \\servername\d$\sharefolder\tm1servername\Data "Set TextStream = FSO.Open...

Oops.....I've totally forget this function and over looked the problem... thanks a lot...I should have think twice before I post

Hi Experts, Quick Question, is there a function or syntax to retrieve a weight of a consolidated element, little google gives me a "TM1DimensionElementComponentWeightGet" VB function and I'm not quite sure how to use this. In other word, can we retrieve the details in property pane of a co...

to add up, I was wondering how could we know whether its active or inactive by just looking into .cho file, Finally found
533, 1- Active & 0 - Inactive chore.

Thanks "failurehappening"

That's Kewl stuff to note....thanks & its very helpful by the way what if the people who are using the client tool alone (perspective)...just curious to know

I hope the best practice is to give the "CHORE_NAME (Weekly/Daily <day> <time> <am/pm>)"