TM1 Forum

Actually, you _can_ run mixed versions, but not as services. You have to have the relevant versions's admin server running somewhere else, then point your foreground server over there. Not necessarily. It depends on how far apart the versions are and whether or not the registered DLLs are compatibl...

the feeder statement is not getting saved Probably due to overfeeding and running out of RAM. When you create a feeder statement you should only feed rule calculated cells that you know will evaluate to something other than 0. What is the condition that causes one of the 80,000 Investment elements ...

I'm about 90% sure that in your scenario, using a lookup cube to determine an element match, that you have to re-process the feeders, either through re-saving the rule or issuing a ProcessFeeders command through TI, in order for it to be dynamic. I have encountered this before and that was the concl...

Have you bothered to read the documentation about how to create TI drill processes? Are you aware of how you can use parameters (the specific elements from the cell you are clicking on) in the WHERE clause of your drill-thru query to return only the records you want? It's all in the documentation.

The answer to your problem is to remove the customer from your channel dimension and make it a separate dimension. That way a particular customer's data can show in one channel for one period and in another channel for another period. When you combine customer and channel, and you have situations wh...

You must not have looked very hard. Right next to SubsetCreate in the documentation there is a function called SubsetCreateByMDX.

What are you trying to name this new attribute? You can't use the name YEAR because that is a reserved word as it is also a rules language function. Try a slightly different variation on the name and it should work.

When you save rules, three things happen; 1) the rules syntax is checked, 2) rule validity is checked, and 3) feeders are processed. When a rule save takes a long time, it is almost always due to item number 3. My guess is you have a problem with your feeders but we can't help you without more backg...

I suggest you take some training, or at a minimum, read the manuals. Zero-suppression is quite easy in the cube viewer and in active form reports.

anoops81 wrote:I tried to implement it with rules in the element security control cube but ADMIN was able to edit the cells , of course Admin is supposed to have all rights.

If a cell is locked even an admin can't change it. Did you refresh security after applying the "LOCK" value via the rule?

There is no security role that can do all the things you want except straight admin. You can accomplish most of what you want by creating a custom security group and giving that group admin access over the cubes you want. However, they won't be able to create their own cubes. An admin would have to ...

AFAIK, there is no way to do this with MDX. Keep in mind, there isn't just one group for a user, there can be multiple ones. I know how to create an MDX query on the }Groups dimension that returns all the group elements that a users belongs to but why do this? What I would do in your scenario is to ...

I use range names all the time in active forms and have never experienced a problem in Excel or TM1Web. However, I usually don't give a range name to the cell that contains the VIEW statement. Try leaving that parameter as the cell reference and use range names in the others. Also, make sure that yo...

It shows the last time that the attributes of the time dimension has changed. It probably is keying off the LAST_TIME_UPDATED value in the }DimensionProperties cube. That key is there because the replication and synchronization routines need it to know whether a dimension needs to be updated on the...

AFAIK, the only way ot change it will be with a re-install. The LANG parameter only controls the TM1 interface, not logging, and there is nothing in the tm1s-log.properties file that controls the langauge of the logging. There is probably a key in the registry of the server that holds this but I hav...

Make sure Autorecalc is turned OFF in the workbook and make sure TM1Web is configured to always inherit the Autorecalc setting from the workbooks.

It's not supported in TM1 because it simply doesn't make any sense in an OLAP environment! How could you possibly have an array in a cube other than a grouping of elements like that defined by a consolidation????? You can only store one value in a cell in TM1, not an array. Technically you could def...

When I re-opened the dimention in the Dimention Editor I saw a strange picture: there appeared 4 copies of the other elements 2,3,4,5 below the hierarchy (!). I've got two elements named "2", two elements named "3" etc... all these elements exist in the same dimention! No, you D...

I don't know the answer for sure, probably only one of the legacy programmers from Applix will know for sure, but I highly doubt the feeders logic is smart enough to know that the rule for a cell has been stetted out. The rule is totally independent of the feeder. They are two different steps in the...

What exactly is wrong with the screenshot? It shows you with 7 leaf elements and 1 consolidation element. 4 of the leaf elements are also children of Total1. Where is this doubling you are referring to?