}ApplicationEntries help

Post Reply
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

}ApplicationEntries help

Post by Darkhorse »

Hi all

does anyone have any idea how to TI this dimension?

i tried the usual
vDimensionName = '}ApplicationEntries';
vConsol= 'Models\02 Count\02 Dimensions\Control Cubes';

#DimensionElementInsert(DimName, InsertionPoint, ElName,ElType);
DimensionElementInsert(vDimensionName,Vconsol,'}ElementAttributes_Assumption Inputs','n');

But it never works,

anyone else had any luck?

:roll:
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: }ApplicationEntries help

Post by Michel Zijlema »

Darkhorse wrote:Hi all

does anyone have any idea how to TI this dimension?

i tried the usual
vDimensionName = '}ApplicationEntries';
vConsol= 'Models\02 Count\02 Dimensions\Control Cubes';

#DimensionElementInsert(DimName, InsertionPoint, ElName,ElType);
DimensionElementInsert(vDimensionName,Vconsol,'}ElementAttributes_Assumption Inputs','n');

But it never works,

anyone else had any luck?

:roll:
If you manually add the '}ElementAttributes_Assumption Inputs' cube reference to the application tree, you can see that what will be added is a '}ElementAttributes_Assumption Inputs.cube' reference. This then is the label of a file with that name in the '}Applications\Models\02 Count\02 Dimensions\Control Cubes' folder in the TM1 database directory describing the linked object.
So, in other words, the link is indirect and cannot be added in the way you're trying to do this currently.
An ApplicationsAdd function would be helpful here...

Michel
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: }ApplicationEntries help

Post by Darkhorse »

is there such a function?
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: }ApplicationEntries help

Post by Michel Zijlema »

Darkhorse wrote:is there such a function?
Not in TI (according to the documentation).

Michel
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: }ApplicationEntries help

Post by Darkhorse »

Hi

I found a work around, Looking at your .cube short cut file found on the server i recreated the shortcut inside of Excel, then using a list of Cubes and Dimensions on another sheet created a looping macro to create all my .cub .dim .proc shortcuts and got the macro to save them to my main folder.

from there i transfered these files into the application folder of my choice manually,

I then ran the same TI as below with the correct names of the shortcuts in, it did not need the .cub/dim/proc ending and i would like to point out that when the TI ran regardless of what my Vconsol was set to it still sat outside the hierarchy, once the server had been restarted the shortcuts showed in the application entries in the correct folder of the shortcuts. i put the shortcuts into a diffrent location to my Vconsol and found they still linked up to the correct folders regardless.


vDimensionName = '}ApplicationEntries';
vConsol= 'Models\02 Count\02 Dimensions\Control Cubes';

#DimensionElementInsert(DimName, InsertionPoint, ElName,ElType);
DimensionElementInsert(vDimensionName,Vconsol,'}ElementAttributes_Assumption Inputs','n');


this sounds alittle long winded i know but its a three step process that takes 2 minutes to run, i found that just grabbing and dropping the required Ti's, Cubes, Dimensions was taking hours especially if the server was heavily loaded with models. if anyones interested in the excel sheet send me a private message will be glad to email it on if needed.

thanks anyway for your help guys, if anyone can find a quicker solution please feel free to add it here..
Post Reply