TM1 Forum

Not understanding the concept of dynamic calculations, caching of results, etc. with TM1 will severely hamper your ability to do much anything of value development-wise. Not really wanting to get into an arguement about this. Just that you shouldn't assume people know nothing, and have never done, ...

Firstly thank you for your help and taking the time to respond.

Secondly, no need to be so patronising. Bit harsh that! (However great/amazing you are at understanding the concepts in a RAM-based OLAP modelling. Or how many TM1 manuals you may have read, or presumably written)

Hello, I have cube which is 350 MB in size ('Memory Used'), quite small. The cube is mostly fed from 4 source/assumption cube data and then multiplied by a volume. When the server has been restarted the cube can take 10 minutes to open (i.e. not time for server to come up on restart, but time after ...

I have a source cube: DB('Volume',!Version,!Time_Month,!New Used,!Market,!Model,!Volume Measures) And a target cube: DB('Contribution',!Version,!Vs. Version,!Variance Type,!Time_Month,!New Used,!Company Code,!Market,!Model Year,!Model,!Currency,!Contribution Measures) I want to pull the Wholesales v...

Thanks all for your excellent replies

Hi Michael,

Thank you for your reply. I have implemeted this and it seems to work of (just need to adjust the TI to remove 'Total' group names with only one child). Certainly produces the numbers I need.

Christopher,

Appologies but I don't really understand your comment.

Cheers,

Adam

I have a problem. Trying to get our HR guys on board with TM1. They have a HR structure in our accounting system (SAP) called org unit. Here is my problem: Consolidated items contain their own values that need to be added to the consolidation, as below. CEO (1) ---- PERS (20) ---- IS (25) ---- FIN (...

Thanks for that.

I was worried that deleting the cogserver.log file would cause a problem, but I guess that file never gets older than the last time Cognos was used.

This question has just popped up for us.

We want to delete older log files but are not sure which ones we need to keep hold of.

Also have Cognos Express.

Just as a follow up to this for those who may be interested. To get the top level ('C' in the example) I had to put an or (%) in my formula as below.

Thanks for all your replies. I have seen the bedrock site and used some of the code on there. Makes things a lot easier as I get something that works and can then pick it a apart to understand how, rather than sitting here scratching my head.

The elisanc is exactly what I was looking for.

Cheers!

Hi, Does anyone know of an easy way to copy part of a dimension to another dimension through TI? Example being the below. The dimension has multiple alternate hierarchies and I want to create a new dimension made up of just C and its children. A --1 --2 --3 B --1 --3 C --1 --2 --3 (the numbers are c...

hmmm...I may need to retract my claim. The feeder rule works for an extra month each time I press save...I don't get it...

Not sure how things should work but that space makes all the difference. Took the space out and restarted the server, feeder doesn't work as I want it to, put the space back in and everything is fine again!

We have Prod and Dev servers for CX. We had to buy another 'Connector' (whatever that is)

It's OK. Done it now.

Had a space missing between AP and the number....Doh!!

Thanks for that. I think we're almost there now!!!

Last issue (hopefully).

In the destination cube the start month is being fed but the months after are not. They appear but do not consolidate. (I have a feeling that didn't make sense so I've added a picture)

It is supported however there are a few issues. 1. The install program does not work. to get round this we copy the files in program files manually (back end install) 2. There a 3 main Excel functions when viewing a cube (Slice, Snapshot, and Active form). Clicking active form and then using it in e...

Whorty,

Plenty of data spreading and breakback functionality, including growth % and proportional spreading etc. Not sure about public docs, but the IBM help guides are pretty decent, and other than that this forum has been very helpful.

Whorty, We are currently implementing Cognos Express at the moment. There are restrictions on the number of licences, and number of instances per server (and everything is on 1 server!). From the TM1 perspective there doesn't appear to be a lot missing. From the BI perspective I believe there are so...