" Insert Cube references" window in Rules Editor ...

林玫玫

Hello All,

I am new to TM1 and practicing to get hold of it.
I am facing a crazy issue. The reference column in " Insert Cube references" in Rules editor, is missing for all my available cubes except the cube I want to load data into.
e.g,I want to load data from ' Bank key Indicators cube' into 'G3 TI cube', but i see missing references for ' Bank key Indicators cube'.

Can you please help me with this. Thanks.

caoshuo594

I presume you are pressing the square brackets button; that just allows you to enter relevant components for the shorthand DB function (which can only be used on the right hand side of a rule to pull NUMERIC values from the destination cube.)

Press the DB button instead and it gives you the longhand option to select other cubes (and string values if desired.)

AM哥

I used db function correctly to select other cubes.
The issue is I am not able to see references to insert from other cubes.
I can select individual elements in the cubes by selecting subset icon next to reference, but I cant select entire dimension (which come with !).
I hope you get the issue. It's happening  for all cubes,don know  if it's  the issue with rules  editor.
I have attached the screenshot of the same.
Thank you.

zplwf

Seems to be working fine to me.

The Reference column will only be populated where the two cubes share dimensions. Given your dimension names seem to imply that each cube has a unique set of dimensions (which, if true, is something you should seriously consider the implications of), then how can TM1 be expected to guess what the reference would be?

If you have two dimensions that contain the same elements - or at least, a subset of elements that you want this rule to apply to - then you are going to have to resort to typing the !<dimname> reference yourself. You can do this either in the Insert Cube Reference box, or insert the rule without entering anything and then enter it in the Rules editor. Note that the !<dimname> has to be a dimension in the cube that you are writing the rules, not the cube you are linking to.