TM1 Forum

I posted something similar in the original thread but as to the usefulness of this as a feature. Let's have a think from the developer's perspective. ("Developer" in this context could mean IBM software engineer or TM1 developer ...) Subsets may be invisible to rules but rules are quite ob...

I would like to replace the following code in our Payroll Budget cube rule: ['Contract Increase', {'01.71.2752000','16.71.2100000','16.71.2756000','16.71.2758010', '16.71.2758020','16.71.2758040','16.71.2760100','16.71.2760200', '16.71.2760300','16.71.2760400','18.71.2750000'}, {'70200928U','702010...

Default expiry time of what exactly?

I'm with Loadza on this one. The usual way to "sum by attribute" in TM1 (without using fancy MDX) is to use TI to build hierarchies based on attribute flags. Put quite simply hierarchies are how TM1 handles additive and subtractive (and weighted) summation. If there is a requirement to als...

You could use element security to limit the cost centers that users have access to to only those that are relevant to them. Then you can use a single cost center dimension. However since it seems that data is in separate cubes this may not be necessary. If you are not concerned that users can see co...

That's still a strange way to implement rollback though, surely? 1. Rollback requires logging in some form. 2. If logging is turned on we can use the file to rollback. 3. If logging is turned off then we can either, a)Turn logging on in the background, b)Develop some entirely new functionality to h...

Is this really 9.4-specific, though, or 9.1 onwards? As far as I'm aware this "memory leak" due to logging doesn't affect 9.1 the way it does 9.4. Rollback seems to be far improved in 9.4 vs 9.1 and I suspect this bug is an unintended result (although why this wasn't foreseen begs a few q...

Ajay You can't apply a native TM1 filter in a dynamic slice. To do this in an Excel view you need an active form in 9.4 and then it is really easy to set up. However this doesn't mean that you can't achieve a similar result in 9.0, you will just have to use a few tricks. There are a couple of ways t...

Hi Martin I am pretty sure you will find that your issue is associated with cube logging not being turned off somewhere in the batch upload process. In 9.4 the log file is not continually written to disk with each transaction but held in memory and committed at the end of the process with the data c...

I have a conundrum about how title attribute of view would affect TI Subselect ... I'm firmly with Alan on this one. Although a "user cube view" and a "data processing cube view extract" both exist without apparent distinction as "cube view" objects on the TM1 server t...

SubsetCreate( 'dimChartOfAccounts','ALL') ; .... If you do this you get a Subset called ALL that is undeletable or editable. Although no members have been added it has All of the dimension in there. It is not an MDX based subset but it dynamically updates once you change the underlying dimension. I...

But doesn't the physical amount of memory on a 64 bit box limit it? If there's only 16GB of RAM and the model hits 16.1GB won't that cause a crash of the type described? In my experience no. In Windows x86 the OS imposes a 2Gb (or 3Gb) upper limit per application, if TM1 breaches the limit then we ...

You could use the ConsolidateChildren function but I wouldn't recommend it in a large (or even moderately sized) cube as it is a real performance killer. You are better off to calculate on load and populate into a smaller cube with appropriate dimensionality or else do as Peter has suggested and wri...

Hi Dave, I take it you have already read the "designing cubes" section of the developers guide? ... and you want more information on the mythical "cube optimization or dimension ordering"? The "smallest densest to largest sparsest" rule of thumb was summed up pretty nic...

What the rules are going to look at will depend on the depreciation method. One thing I would recommend is to use a cube with a combined year-month dimension for calculating depreciation as many depreciation methods can then be calculated using consolidations or a combination of consolidations and r...

Edit: looks like Alan beat be to it but I'll post 2c anyway This is an interesting thread. Indeed your fail over solution does seem like excessive overkill. Your system seems set up to account for a freak hardware failure event on the primary server and have the secondary server up as quickly as pos...

I am using a simple .csv file (that has 2 columns - one for cube name and one for cube view) as the data source for the process. I read this list in and for each row use the cube name as DataSourceNameForServer and the view name as DatasourceCubeview. (I have checked that the correct values are bei...

I am having quite a few problems with Spreading in the Cube Viewer and in Perspectives, most of the time I am getting the error message 'Spreading Operation has failed because the content of the cells cannot be modified'. There are no rules in the area I am trying to manipulate.... Ahhh, but do you...

If your source supports polling for changes in tables you can also dramatically cut down on data volume and load time with a "trickle-feed" approach and do a cumulative load to the cube without a zero out. Locking with an SQLFetch is always problematic as this holds TM1 hostage to load on ...

Trap for young players (and older players too, as I learnt this the hard way not three weeks ago). If you copy an attributes cube in the back end so that it is supposed to reference a new dimension it won't work, as the dimensions that make up a dimension are written inside the .cub file itself, wh...