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.
" Insert Cube references" window in Rules Editor
-
declanr
- MVP
- Posts: 1828
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: " Insert Cube references" window in Rules Editor
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.)
Press the DB button instead and it gives you the longhand option to select other cubes (and string values if desired.)
Declan Rodger
-
jgd108
- Posts: 3
- Joined: Sat Feb 01, 2014 1:51 am
- OLAP Product: Cognos 8.4,10
- Version: 9.5
- Excel Version: 2007
Re: " Insert Cube references" window in Rules Editor
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.
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.
- Attachments
-
- Sceenshot
- image.png (85.58 KiB) Viewed 3728 times
-
Andy Key
- MVP
- Posts: 352
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: " Insert Cube references" window in Rules Editor
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.
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.
Andy Key