VUE files in the TM1 data directory

Post Reply
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

VUE files in the TM1 data directory

Post 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 );
Last edited by Wim Gielis on Wed Mar 08, 2017 6:18 pm, edited 2 times in total.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: VUE files in the TM1 data directory

Post 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?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: VUE files in the TM1 data directory

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: VUE files in the TM1 data directory

Post 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
Ty
Cleveland, TN
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: VUE files in the TM1 data directory

Post 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 ;-)
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: VUE files in the TM1 data directory

Post 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 ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: VUE files in the TM1 data directory

Post 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.
Ty
Cleveland, TN
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: VUE files in the TM1 data directory

Post 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.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: VUE files in the TM1 data directory

Post 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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: VUE files in the TM1 data directory

Post by Wim Gielis »

Thank you for your continued interest :-)
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply