Page 1 of 1

VUE files in the TM1 data directory

Posted: Sat Feb 25, 2017 7:43 pm
by Wim Gielis
Hello all,

If you create a public view on a cube, the corresponding vue file will be placed in the TM1 data directory in a folder specific to the cube.
However, when a TI process creates a cube, subsets and a view, the vue file will be put directly in the data directory, not in the cube folder.
When the TM1 model is restarted, however, the cube folder is created and a vue file is put in that folder. But the original vue file straight in the data directory, is not removed.

I find this all annoying. Not only should TM1 create the folder and put the vue file in it, even if it cannot, it should remove the original vue file to clean up objects.

I observe it with the latest version of TM1 but probably it's been there for a long time.

What do you think ?

Obviously I don't want to run a startup chore to delete *.VUE files.
TM1 should not behave like this in the first place.
We want to prevent this thing from happening rather than clean up the consequences.


TI code to replicate the problem - FILL IN vDim1 and vDim2 with existing dimension names:

Code: Select all

vCube = 'test';
vView = 'Wim';
vSubset = 'Wim';

vDim1 = '';
vDim2 = '';

CubeCreate( vCube, vDim1, vDim2 );

SubsetDestroy( vDim1, vSubset );
SubsetDestroy( vDim2, vSubset );

SubsetCreateByMDX( vSubset, '{TM1FilterByLevel( TM1SubsetAll( [' |vDim1 | '] ), 0)}');
SubsetCreateByMDX( vSubset, '{TM1FilterByLevel( TM1SubsetAll( [' |vDim2 | '] ), 0)}');

ViewCreate( vCube, vView );

ViewSubsetAssign( vCube, vView, vDim1, vSubset );
ViewSubsetAssign( vCube, vView, vDim2, vSubset );

Re: VUE files in the TM1 data directory

Posted: Sat Feb 25, 2017 10:28 pm
by lotsaram
Never noticed. I will have to check it out and let you know if I see the same thing. I take it from your description that the cube creation and view creation has to happen in the same TI process for this to happen?

Re: VUE files in the TM1 data directory

Posted: Sat Feb 25, 2017 11:23 pm
by Wim Gielis
lotsaram wrote:Never noticed. I will have to check it out and let you know if I see the same thing. I take it from your description that the cube creation and view creation has to happen in the same TI process for this to happen?
Hello lotsaram,

Even in the case of 2 processes, the second process being called with ExecuteProcess, the same behaviour occurs: a *.vue file straight in the TM1 data directory.

The use case is the following. I have a number of generic TI processes, like a process that creates a cube containing all cubes and their dimensions in the TM1 model.
Or another process that creates a cube containing all TI processes and their properties, by reading the *.pro file contents.
To these processes I add (in the Epilog tab) code to create subsets and views such that the user (or I :-) ) does not lose time when using those extra cubes.
Put simply, a good Default view that has the layout and presentation I would like to see 90% of the time.
It all works fine but these *.vue files that are not in the correct folder are annoying.

Re: VUE files in the TM1 data directory

Posted: Wed Mar 01, 2017 11:55 am
by PavoGa
Wim,

Checked our DEV and PROD instances and did not see anything like this that has happened, nor have we seen this at anytime in the past, but most things we create on the fly have a 'tmp_' prefix and cleanup chore runs every night to get any strays. Ran the provided code, but it created the cube's }vues folder and placed the new view in it.

We are on 10.2.2.

Ty

Re: VUE files in the TM1 data directory

Posted: Wed Mar 01, 2017 4:39 pm
by Wim Gielis
Hello ty,

Indeed, I have the *feeling* that it is something recent, since PAL.
Me too, I think I didn't see it earlier.
The fact that Lotsaram did not see it either, is more evidence that it is a recent phenomenon ;-)

Re: VUE files in the TM1 data directory

Posted: Wed Mar 01, 2017 10:09 pm
by Wim Gielis
PavoGa wrote: and cleanup chore runs every night to get any strays.
Does your chore also look for vue files in the data directory ?

Re: VUE files in the TM1 data directory

Posted: Thu Mar 02, 2017 10:30 pm
by PavoGa
Yes. it just looks for any object with 'tmp_' as a prefix and gets rid of it. Occassionally it's aggravating when you really wanted that view from the previous night... :lol:

I have not refined it check out clients' subfolders.

Re: VUE files in the TM1 data directory

Posted: Mon Mar 06, 2017 9:59 am
by David Usherwood
@Wim, I did experience this when testing PA Local 2.0 - but going back to it just now it did not recur - the new views were written into the <cube>}vues folder. I had been testing ViewCreatebyMDX which is quite odd - the view files have a .xbv extension and are not visible in the 'Rich Clients' (Architect/Perspectives) after creation. They can be accessed using DataSourceCubeView. They are visible in PAW but error when opened. More work needed I would say.

Re: VUE files in the TM1 data directory

Posted: Mon Mar 06, 2017 12:37 pm
by lotsaram
Hi Wim,

I tried to replicate in 10.2.2 FP6 but couldn't. Even when creating a cube and view in the prolog of a single process the behaviour is as expected and a cube}vues folder is created with the .vue file there.

When I get the chance I will try with PAL 2.0.

Re: VUE files in the TM1 data directory

Posted: Mon Mar 06, 2017 2:30 pm
by Wim Gielis
Thank you for your continued interest :-)