Add Files to Application via process or vba

[pobrouwers]

Hello Everybody,

Is it possible to create a folder and add a file into this folder in Application. This via process or via a script VBA.

Thx

[Paul Segal]

Do you mean create a folder and add a file to it from Excel? Then the answer is yes - probably best to google some excel VBA sites for the code for this.

Regards

Paul

[pobrouwers]

Hello Paul,

No in fact, add a file to Application in TM1 explorer

[pobrouwers]

I've found.
It must to add element in the dimension }ApplicationEnties with this code and create folder and blob into }Applications folder.

Code: Select all

vDir = 'TEST 999';
vBlob = vDir | '\' | 'TEST.blob';
vDimensionName = '}ApplicationEntries';
vTopName = '}Applications';


DimensionElementInsert(vDimensionName,'',vDir,'C');
DimensionElementInsert(vDimensionName,'',vDir,'n');
DimensionElementComponentAdd(vDimensionName, vTopName, vDir, 1.000000);
DimensionElementComponentAdd(vDimensionName, vDir, vBlob, 1.000000);

That's works but the problem is that I must to restart the server to reload all objects.
How refresh the list object in application folder without stopping and starting the server TM1 ?

Thx

[Steve Vincent]

Does pressing F5 in the server explorer work? It does when i add a new cube and someone else wants to see it who was already logged in, but not sure if it would in this case...

[pobrouwers]

I've tried F5 but it doesn't work...
Any ideas ?

[pobrouwers]

Hello,

Who's an experience with tm1 api and more specialy TM1BlobCreate, TM1BlobPut,...
Do you have some examples ?

Thx

[Steve Vincent]

The API in that case is probably all you have left as an option. I've never delved that deep so i can't help on that front i'm afraid...