TM1 Forum

Apparently Microsoft recently added that to their latest Excel upgrade patch and it's "The implicit intersection operator was introduced as part of substantial upgrade to Excel's formula language to support dynamic arrays". A link to their support page: https://support.office.com/en-us/art...

I believe you can't use cell references in SUBNM statements to identify the server and dimension, at least in v 9.5.2 Here's a quote from the section on SUBNM statements in the IBM Manual: "Note: Do not use cell references as arguments with the SUBNM function. Cell references prevent the functi...

This is probably a bit late, but why couldn't you separate the accounts and groupings you have into 2 dimensions? I'm thinking of a dimension simply being "Direct", "Indirect", etc. and the other one being the individual accounts of "Wage","Bonus", and "O...

Do you have any of the parameters dpendent on results from another cell? I've run into issues in the past where a caluculated result is needed to feed one of the TM1 cells resulting in no values (just a message like "N/A" or "RECALC" appearing. I believe it's because the DBRW sta...

What version are you on? I believe that prior to v9.1, there was a limit on the number of security groups that could be created during any session regardless of what the parameter was set to.

I believe that Zap is a function out of the Revelwood Application Manager and is not native to TM1.

The number of groups that you can create in one session may also be dependent on the version you're running. I recall that prior to v9.1 there was a maxium limit of somewhere around 100 even with the cfg parameter. I think starting with v9.1 you could specify a more much larger number. I don't recal...

If it's an alias, did you move the attribute control cube and associated dimension as well?

This might be old and incorrect info, but I seem to recall in speaking with an IBM rep over a year ago that moving from a 32 bit (which many older ones are) to a 64 bit environment would be a change in licensing that would trigger the per seat issue. This being IBM, things may have changed in the la...

Just to add, I found that once I exceeded a couple of hundred security groups the time it took to update through the regular GUI was painfully slow. I ended up handling the updates directly through the control cubes for small quick updates, and TI for anything larger. There was well over 1000 securi...

I haven't used replication in quite some time, but years ago I had a simialr problem which had to do with the internal time on the servers. I don't know if subsequent versions of TM1 resolved the problem, but back then the GMT had to match (or be reasonably close) or the replication would fail.

Are there any rules or TI processes that are atached to this cube?

I've dealt with cubes that contained nearly 50GB of data. If you're able, you might consider only reloading the data that's change or likely to change rather than the entire database. You can refresh the entire cube during the weekends or after hours if needed. This usually works if you're dealing w...

If it's executing when you open the template up, there's probably some vba statements that execute automatically. You want to disable some of these statements since that code will execute before you'll get to a test cell unless that test is also embedded in the auto-open code. Do a google on "a...

Why are all the users in each group with each group having the same rights as the others? The only reason to have different security groups is to differentiate privileges between groups. In your model, I would only have 2 groups. User 1 with Group 1 having only read privileges to cube 1 and read/wri...

The easiest way is just to save & shut down the TM1 server, locate the cubes and dimensions desired, and copy those objects with a different name. Then restart the server.