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:
- For automatic updates of views – changing used subsets, chosen elements of context dimensions;
- Finding what views uses some dimensions subset and etc.
There are 2 more simular articles about Cognos TM1 system codes in files:
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 |