Page 1 of 1
.vue file: Dimension in view row, column or header position?
Posted: Thu Feb 28, 2013 12:21 pm
by holger_b
Is there a way to see in the .vue file which dimensions are in rows, columns and headers? I am currently copying part of a database to a new instance, using MS SQL as an intermediate storage (store all desired structure information and the data in SQL, then import everything into the new TM1 instance). This is the last missing piece of my puzzle.
Any idea?
Thank you
Holger
Re: .vue file: Dimension in view row, column or header posit
Posted: Thu Feb 28, 2013 12:59 pm
by lotsaram
holger_b wrote:Is there a way to see in the .vue file which dimensions are in rows, columns and headers? I am currently copying part of a database to a new instance, using MS SQL as an intermediate storage (store all desired structure information and the data in SQL, then import everything into the new TM1 instance). This is the last missing piece of my puzzle.
Any idea?
Thank you
Holger
Es ist alles enthalten in der VUE-Datei junger Jedi.
Property 374 = number of title dimensions
thereafter follows listing of title dimensions (& elements) on subsequent rows (property 7 = dimension name, property 6 = subset name)
Property 360 = number of column dimensions
thereafter follows listing of column dimensions (& elements) on subsequent rows
Property 371 = number of row dimensions
thereafter follows listing of row dimensions (& elements) on subsequent rows
Note if the view doesn't use named subsets for each dimension then for dimensions without a named subset there will also be
Property 270 = number of member set items thereafter follows listing of elements
Re: .vue file: Dimension in view row, column or header posit
Posted: Fri Mar 15, 2013 2:53 pm
by holger_b
Hi lotsaram,
perfect, thanks a lot! Can you give similar enlightenment as to subsets?
Möge die Macht mit Dir sein
Holger
Re: .vue file: Dimension in view row, column or header posit
Posted: Sun Mar 17, 2013 5:45 am
by rmackenzie
holger_b wrote:perfect, thanks a lot! Can you give similar enlightenment as to subsets?
A full list of property codes is given in the Java documentation when you select that item as part of your Perspectives install. It is a HTML file so you could paste this into your browser and it should come up if you have it installed:
file:///C:/Program%20Files%20(x86)/Cognos/TM1/API/JAVADOC/constant-values.html#com.applix
E.g.
SubsetAlias - 274
SubsetElements - 270
SubsetExpandAbove - 281
SubsetExpression - 275
SubsetPseudoelement - 277
SubsetWidth - 276
Re: .vue file: Dimension in view row, column or header posit
Posted: Mon Mar 18, 2013 10:13 am
by holger_b
ah, great - thanks a lot!
Best regards
Holger