.vue file: Dimension in view row, column or header position?

[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

[lotsaram]

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

[holger_b]

Hi lotsaram,

perfect, thanks a lot! Can you give similar enlightenment as to subsets?

Möge die Macht mit Dir sein

Holger

[rmackenzie]

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

[holger_b]

ah, great - thanks a lot!

Best regards
Holger