TM1 Forum

I got around that issue by killing off the idea of the second cube. I made a view of our P&L cube, sliced into Excel, and then hard coded the value and pressed Shift F9 to upload the value back into the cube so that it consolidates... Kudos goes to a colleague of mine which suggested this approa...

Unfortunately it's not working. :x I am referencing a value in the Allocation Adjustment cube and pulling that into the Trading Statement cube. So, the value displays but does not consolidate. Should the dimensions in the allocation adjustment cube be the same as the trading statement cube (e.g. yea...

Hi, I resolved the feeder issue and got the consolidation going by hard coding the profit centre, switching from !profit centre to a hard coded value. Is this best practice? Also, In the overhead allocation, I have two cubes (Overhead Allocation & Overhead Adjustment), one to allocate overhead b...

There wasn't really much to fix. The code I had in there worked. I had missed the fact that the rule had worked, however the consolidation didn't - which is addressed below. When I am viewing through the cube viewer, on individual months (e.g. July) the data appears, however on the consolidated grou...

Hi guys,

Thanks for your help.

I've worked it out.

Another issue I'm having now is that my data is not rolling up into the consolidated view level. Can anyone provide some tips on what I should do?

Thanks.

Hi Michel, Thanks again for the reply. I tried this code outside of skipcheck and feeders (i.e. above it) with no luck. It's bizarre because the first statement works and then I try the second statement and it will not populate the rows with values. The only thing that has changed is the accounts. A...

Hi Michel, Thanks for the speedy response. I'm fairly new to TM1 although have used other BI tools in the past so apologies for my lack of knowledge. The difference between SSA % and other field is intended - apologies I didn't pick this up though when I copied the code into the post. Skipcheck and ...

Question for Alan and others in the know: I am continuing some TM1 work left from a colleague where we are automating our P&L in TM1. Essentially I would like to reallocate a bucket of costs to different categories based on a percentage I have allocated in an allocation cube. Below are two code ...

Hi Alan, Thanks for the reply - I've got a server setup at work, and have been able to use the sample data included and have worked through some of the examples. You're right though, at the moment, all the concepts seem to be in isolation and I'm having difficulty linking concepts together. At the m...

Hi guys,

I've started using this program and the manuals supplied, while helpful still don't fully explain all the features of TM1 and thus I'm having trouble bringing it all together.

Any materials online or books that you recommend that I should get?