TM1 Forum

Hello,

I have a time dimension, it is used in multiple cubes:


For most of the cubes (except one) I need all weights to be 1. For one specific cube, for some months, I need weights to to be 0; that is, specific months should not be included in hierarchy aggregation (in my case, values in March, April, May, October and December should be ignored in quarters and year aggregations). These specific weights are stored in dimension attribute "PSsvoris".

Is it possible to write a general rule(s) to do aggregation on this attribute "PSsvoris"?

It's best to avoid rule-based aggregation as hierarchy-based consolidation is a lot faster.
You would be better off creating an alternative hierarchy in your dimension designed specifically for that one cube's roll-up method. Alternatively, you can use a different time dimension.
If you still want to use rules for consolidation and want to base these rules on attributes, then yes, this is possible.

In this instance I think you would be best served by creating a separate time dimension for the specific cube in question.

lotsaram wrote:In this instance I think you would be best served by creating a separate time dimension for the specific cube in question.

Is there a way to "swap" dimensions in cube? I have dimension "Time" in my cube and I've created "Time2", is there a way to change the dimension without recreating the cube?

Nope

Steve Vincent wrote:Nope

Not true. As long as you are comfortable with stopping the TM1 service and editing the affected cube file(s) directly in a hex editor then dimension names can be changed. Providing no mistakes in the number of characters in dimension names and as long as the new dimension matches the old dimension for all leaf elements where data is held then when the server is restarted no data will be lost and the cube will point to the new dimension(s).

How to do this is described here in this post http://www.tm1forum.com/viewtopic.php?p=22780

Note: what you can't ever do without creating a new cube is to add or subtract dimensions from a cube.

Warning: this is essentially back door hacking and could be described as an "advanced" technique not for beginners and certainly not for the faint hearted. Anyone attempting this should back up the data directory first (kinda goes without saying).

A TM1 development tool that could facilitate doing this "automatically" via a GUI would be extremely useful IMO. Hint, hint to those out there who are selling TM1 development tools, this would be a nice addition.

lotsaram wrote:

Steve Vincent wrote:Nope

Not true.

I know, but in the world of doing things in production the last thing i'd suggest to do is hack around in hex editors. Unless you really know your stuff the chances of calamity are large, hence the reply

I've edited hex files and changed the dimension with no problems at all (at least, with no visible problems ). Thank you everyone.