/ Cognos

Definition of system lines in Cognos TM1 Views files (.vue)

In this article I will disclose information about how Cognos TM1 stores information about cubes views in .vue files. For Cognos TM1 developers this information can be usefull in many different situations, for example:

  1. For automatic updates of views – changing used subsets, chosen elements of context dimensions;
  2. Finding what views uses some dimensions subset and etc.

There are 2 more simular articles about Cognos TM1 system codes in files:

  1. Definition of system lines in Cognos TM1 Subset files (.sub)
  2. Definition of system lines in Cognos TM1 Process files.

1

In the image above you can see the view and below you can see the code of it from .vue file.

There are multiple ways how developer can define appearance of some dimension in the view: with predefined subset, as custom list of elements and as list of all elements. To make the description of file more clear, I replace this information and explain it at the end of this article, defining all available options. Places in the code are replaced with lines: <-- Block of code that defines dimension, look below -->.

Code description

Code Description
389,100 Encoding of file, 100 for utf8
390,"View" Name of the view
370,0 ?
361,1 ?
362,1 ?
363,0 ?
364,0 ?
365, ?
366, ?
367,0 ?
376,0 1 if auto recalculate is turned on, 0 otherwise
375,b:0.0 Default format for numbers in cells
Start of dimensions in context
374,3 Number of dimension that are in the context positions. In this example there are 3 dimensions. After this code list of dimensions in context and there definitions are coming
7,D1 Name of dimension that is located in context position
<-- Block of code that defines dimension, look below -->
7,D2 Look 7 above
<-- Block of code that defines dimension, look below -->
7,D3 Look 7 above
<-- Block of code that defines dimension, look below -->
Start of dimensions in columns
360,1 Number of dimensions in columns. In this example. In this example there is only one dimension in rows. After this code list of dimensions in columns and there definitions are coming
7,DMeasure Look 7 above
<-- Block of code that defines dimension, look below -->
Start of dimensions in rows
371,1 Number of dims in rows positions. In this example there is only one dimension in rows. After this code list of dimensions in rows and there definitions are coming
7,D4 Look 7 above
<-- Block of code that defines dimension, look below -->
373,3 Default values for dimensions that are located in context are coming after this code. 3 is number of such dimensions in current example
1,Total Default value for first dimension in Context (in this example for dimension D1). 1 is index of this element in dimension
1,Total Default value for second dimension in context
1,D3.EL1 Default value for third dimension in context
372,0 Suppress zeros for rows
372,00 Suppress zeros for rows (first number) and columns (second number)
384,0 Suppress zeros for rows (again);
385,0 Suppress zeros for columns
377,4 ?
<-- Some numbers -->
378,0 ?
382,255 ?
379,5 ?
11,20190731144247 Time of last edit in format (YYYYMMDDHHMMSS)
381,0 ?

Defining list of elements or subset for some dimension after 7 code

Use subset as dimensions list

Code Description
6,Name of subset If you specify subset for dimension it's name will be placed in this code

Use custom list of elements as dimensions list

When you specify custom list of element for dimension in view this syntax is used. For more information look article about codes in .sub files.

Code Description
270,3 Define number of elements in custom list. In this example there are 3 elements in it
<-- List of elements --> Here comes list of element, one element for each line
274,AliasName User can define what alias will be used for custom list. In this example alias "AliasName" is specified
275, If subset was created by system using MDX expression, then MDX is placed here
281,0 Is expanded above turned on or off
282, End of definition

Use all elements as dimensions list

When you press All button in Subset Editor Cognos uses special system All subset, that contains all elements of dimension.

Code Description
6,ALL ALL is special system subset that contains all elements in any dimension.
274,AliasName For ALL subset user can define what alias will be used. In this example alias "AliasName" will be specified
281,0 Is expanded above turned on or off
282, End of definition