Reopen the same Sheet/Application after closing it

Post Reply
AlvinPresley
Posts: 8
Joined: Mon Apr 18, 2016 2:24 pm
OLAP Product: IBM Cognos Tm1
Version: TM1 Web
Excel Version: 2010

Reopen the same Sheet/Application after closing it

Post by AlvinPresley »

Hello People!

Is there any way I could close an application and reopen it as a new application automatically?

I used the Action button to do that.But the issue I'm facing is; If I select something on a subnm function in the web and then click the action button(which has rebuild sheet and replace the current workbook option checked), the selection becomes the index element of the subnm when it reopens. Is there a workaround where, when i click the action button ,the report should close? And when it reopens,I get the original report that was uploaded on the server?

I hope that you get the idea of what I'm trying to explain..sorry for wrong phrasings!

One way that I thought about is to create a dummy file and the dummy file triggers the previous/required page. So any Idea about how to automatically trigger the file from the dummy application as well?

Or any workaround to do that?
TomBr
Posts: 32
Joined: Tue Jun 03, 2008 6:56 pm

Re: Reopen the same Sheet/Application after closing it

Post by TomBr »

Hi,

If you effectively need a button to reset your Active Form to the way it was originally on TM1Web, (before you made other selections), I can think of 2 ways to achieve this.

1. In your Reset button in Worksheet\Advanced Options you could set
(e.g. if your Subnm was on the Company dimension and was originally on the Company X element)
Source Type: Value
Source Object: Company X
Target Type: SUBNM
Target Object: Company

2. You could save the file as a second file in the application folder and direct the Go to Another Worksheet to that second file and vice versa
This would mean you would have to maintain 2 files rather than 1

Btw, in Excel it works as you require without resorting to either of these options.

I hope this helps.

Tom
Post Reply