TM1 Forum

How will you go along if you have another dimension? Let’s say you have a third dimension named "Area". This dimension consists of the following attributes: "North", "West", "South" and "East". The dimension "Hakon List of Cars" just cons...

Andy, it is unclear to me what exactly you are asking. As I understand it you have two year dimensions, one containing elements like 2009, 2010,... the other one having elements like T+1, T+2,... Are you trying to have an alias on the T+1,... elements that is rule generated, or are you trying to ha...

Thanks cramejia_09, that worked. Just what I was trying to solve.

Thanks to everyone for helping me out!

Put an alias on your year dimension where the alias is t+1 for 2011, t+2 for 2012 etc. Don't forget to update this when you start a new year. Or depending on how quickly your second system changes from t+1 = 2011 to t+1 = 2012 at year end you could use a rule to populate the alias. But this solutio...

Gregor Koch wrote:Hi
Yes, that is possible for example by using Attributes.
Before I move on, did you get the rule working so far? Just for my own sanity.

Hi,

Yes the rule is now running like a charm

Hi, I have two different cubes where both cubes use the same dimension, "Year". The two cubes are updated from two different sources. The first source gives the dimension "Year" values like 2009, 2010 etc. The second source gives the dimension the value "t+1" - which me...

Hi Bilder and Biler? In case you copied and pasted what I have written maybe try starting with the DB button and the replacing the according values yourself. Also just in case try hardcoding element names from the dimensions in the other cube. For a more general explanation: If you have two cubes w...

Hi Not going into details of how this could be done differently from a model perspective by maybe having one 3 dimensional cube, here is the really short solution to your specific problem. 1. The cubes don't need to have a common dimension 2. Yor DB function, although it might be created by TM1, th...

If you have skipcheck enabled in the destination cube you _must_ have working feeders in the source cube. Do you? I have not written any feeders or skipchecks. The only rule I have written is the one above. Maybe it will help if I attach som more pictires: This is a picture of the cube structure: h...

@oleisbest, have you written a feeder to match your rule? I've looked at your screen capture but am a bit puzzled because the row dimension apparently has the same name in each , but the elements 'Sum Car 3+4' & 'Sum Car 1+2' are parents in Hakon Slett and n level in Hakon Slett2. I have not wr...

I think my problem is what described in IBMs help file:

http://publib.boulder.ibm.com/infocente ... 800A7.html

But I dont understand how I can modify this to make it work for me.

Anyone?

Try: ['TALL FRA KUBE2']=N:DB('HÃ¥kon SLETT',!HÃ¥kon - Sum biler,!HÃ¥kon - Liste over biler); The additional "N:" after the equal sign means the rule is applied to only level 0 elements. Did you use the "DB" button in the rule editor to create the rule? Also, you are doing this i...

Thanks a lot cramejia_09! I finally understood the use of consolidated elements :) Unfortunately I can’t get the data to move from cube 1 to cube 2. If you take a look at the picture below you see I have two rater simple cubes :) I would like to transfer the value 20 and 16 from the cube named &qu...

You're treating TM1 as a relational engine, which it isn't. Use consolidation in your dimensions to add up numbers - rules are inefficient for pure adding up. To get the total(s) from one cube into another, use cross cube rules, on the lines of: # in destination, ['Sum 1 +2'] = db('Source',.....'Su...

Thanks a lot guys. I will try it out and see how it works!

I tried getting the DB function to work but all I got was a error message. I will make a new try to see if I overlooked something.

Hey, I have a few questions I hope someone can help me answer :) I am trying to join data from two different cubes. Cube one includes the name of different accounts and account numbers, while cube two includes the accounts on an aggregated level with planned numbers. 1. I would like to use a rule to...