Upload Applications with TI oder Powershell

Post Reply
Memo66
Posts: 26
Joined: Thu Nov 13, 2014 8:42 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: Excel 2010

Upload Applications with TI oder Powershell

Post by Memo66 »

Hi,

i am trying to find a way to deploy applications from dev to prod.
I tried to copy the files into the }Application and }External directories but it doesn't work.

Is there a way i can upload them with a TI or is there any other way?

Memo :)
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Upload Applications with TI oder Powershell

Post by TrevorGoss »

Do you use performance modeler? If so, you can use the transfer functionality within PM.
Memo66
Posts: 26
Joined: Thu Nov 13, 2014 8:42 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: Excel 2010

Re: Upload Applications with TI oder Powershell

Post by Memo66 »

No, we don't use the performance modeler. Just TI's
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Upload Applications with TI oder Powershell

Post by TrevorGoss »

Inside Applications Web, you can export the applications and re import them to your production environment.

The export icon is the 4th icon on the right, in the collection of choices alongside, or underneath all applications.

Trev.
babytiger
Posts: 78
Joined: Wed Jul 31, 2013 4:32 am
OLAP Product: Cognos TM1, EP, Analyst
Version: 10.2.2
Excel Version: 2013
Location: Sydney AU

Re: Upload Applications with TI oder Powershell

Post by babytiger »

What applications are you referring to?

Are these TM1 Application Web/Contributor applications? If so, wouldn't you need performance modeler to create/deploy these applications in the first place?

But based on your response, that you don't use performance modeler. Do you mean the Applications folders that you find within Architect and Perspectives?
MK
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Upload Applications with TI oder Powershell

Post by TrevorGoss »

babytiger wrote:What applications are you referring to?

Are these TM1 Application Web/Contributor applications? If so, wouldn't you need performance modeler to create/deploy these applications in the first place?

But based on your response, that you don't use performance modeler. Do you mean the Applications folders that you find within Architect and Perspectives?

I was assuming they meant Applications within Applications Web, because they spoke of control cubes, such as }applications.

They are on version 10.2.2, so they can use performance modeler.
babytiger
Posts: 78
Joined: Wed Jul 31, 2013 4:32 am
OLAP Product: Cognos TM1, EP, Analyst
Version: 10.2.2
Excel Version: 2013
Location: Sydney AU

Re: Upload Applications with TI oder Powershell

Post by babytiger »

TrevorGoss wrote:
babytiger wrote:What applications are you referring to?

Are these TM1 Application Web/Contributor applications? If so, wouldn't you need performance modeler to create/deploy these applications in the first place?

But based on your response, that you don't use performance modeler. Do you mean the Applications folders that you find within Architect and Perspectives?

I was assuming they meant Applications within Applications Web, because they spoke of control cubes, such as }applications.

They are on version 10.2.2, so they can use performance modeler.
Sorry Trevor, my questions are meant to be for Memo. Not a response to your post. You are correct that applications can be exported and imported from Applications Web. But wouldn't they need to created first, ie. using Performance Modeler. But since Memo mentioned that they don't Performance Modeler, how were these created in the first place?

So, just like to clarify on what we are talking about first.
MK
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Upload Applications with TI oder Powershell

Post by TrevorGoss »

babytiger wrote: Sorry Trevor, my questions are meant to be for Memo. Not a response to your post. You are correct that applications can be exported and imported from Applications Web. But wouldn't they need to created first, ie. using Performance Modeler. But since Memo mentioned that they don't Performance Modeler, how were these created in the first place?

So, just like to clarify on what we are talking about first.

Fair enough, lets wait in anticipation for Memo's response.
Memo66
Posts: 26
Joined: Thu Nov 13, 2014 8:42 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: Excel 2010

Re: Upload Applications with TI oder Powershell

Post by Memo66 »

Hi Guys,

sorry for the late reply.

I found a way to upload applications via powershell

If you manually upload a Excel Sheet or something else, TM1 copies the File with a Timestamp in the folder }Externals.

Example:
IF I upload the File test.xlsx, then TM1 creats the File 'test.xlsx_20160412121502.xlsx'.


TM1 creats also a .blob file in }Applications

Example:
test.xlsx.blob

IF you open this File with an Editor you can see the link to the copie
ENTRYREFERENCE=TM1:///blob/PUBLIC/.\}Externals\test.xlsx_20160412121502.xlsx


so you can also copie a file via powershell in die }externals folder an create a blob file with that link.
You don't need the timestamp.

You may have to restart the TM1 Server to see the files.
babytiger
Posts: 78
Joined: Wed Jul 31, 2013 4:32 am
OLAP Product: Cognos TM1, EP, Analyst
Version: 10.2.2
Excel Version: 2013
Location: Sydney AU

Re: Upload Applications with TI oder Powershell

Post by babytiger »

Memo66 wrote:Hi Guys,

sorry for the late reply.

I found a way to upload applications via powershell

If you manually upload a Excel Sheet or something else, TM1 copies the File with a Timestamp in the folder }Externals.

Example:
IF I upload the File test.xlsx, then TM1 creats the File 'test.xlsx_20160412121502.xlsx'.


TM1 creats also a .blob file in }Applications

Example:
test.xlsx.blob

IF you open this File with an Editor you can see the link to the copie
ENTRYREFERENCE=TM1:///blob/PUBLIC/.\}Externals\test.xlsx_20160412121502.xlsx


so you can also copie a file via powershell in die }externals folder an create a blob file with that link.
You don't need the timestamp.

You may have to restart the TM1 Server to see the files.
May be it's my understanding of what an application is. But personally, I would never call an excel spreadsheet (potentially a websheet) an application.

It's good to hear that you have figured it out.

Interesting way to store/load excel spreadsheets.
MK
Post Reply