TM1 Forum

Hi Sree, It's pretty simple: 1. Do "normal" TI-script to load data in cube "as-is" 2. Go Advanced tab and choose Data tab 3. Copy CellPutN/CellPutS line from "generated" section and paste it below this section 4. In variables tab change your data variable content from &...

This is good starting point: http://publib.boulder.ibm.com/infocente ... ccman.html

Google is also nice friend in these issues

Yes. An abstract answer for abstract question: A TM1 user is very often business intelligence user.

Hi plkkw,

check BEDROCK TI VERSION 1.0 ZIP from http://bedrocktm1.org/. There is a bunch of great TI scripts, including, for example, a script to clone/copy dimension.

-Mikko

oops.. sorry. I didn't notice that you have some feeders in your example. My mistake :) So are trying to calculate average prices in consolidated levels? If that's the case you could try to solve this by adding some extra elements in your dimension and do the calculation for C-levels with those. I h...

Have you ever heard of "FEEDERS"? If not, I strongly recommend to learn the basics of rules and feeders for example from TM1 Rules Guide and TM1 Reference Guide.

One I found very interesting is http://www.amazon.com/Future-Ready-Mast ... 0470747056. It's totally non-technical and there's no a word of TM1 but gives nice picture of the business cases that TM1 is usually dealing with.

In the 9.5.2 NewFeatureGuide I have found the following: "New functions for Rules and TurboIntegrator The following new functions are available in TM1, version 9.5.2 for use with rules and TurboIntegrator: ● ConsolidatedMin ● ConsolidatedMax ● ConsolidatedAvg ● ConsolidatedCount ● Co...

Hi, I am struggling with time and date formats in TM1web. I have a worksheet with time column. I want to input time as format of h:nn (for example 9:30). This works fine in Perspectives but not in TM1web: if I enter 9:30 in cell,the following message is displayed: "Not a number: 9:30 Please use...

Hi Guys,

I am having exactly same problem as Michel. Did you already find a solution for this?

Mikko