Websheet Refresh Button in WORKSPACE

Post Reply
mnasra
Posts: 93
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Websheet Refresh Button in WORKSPACE

Post by mnasra » Wed Jun 12, 2019 7:42 pm

Hi Expert,

I have an active Form with a Rebuild Sheet Button.
When I added the websheet in Workspace the Button does not work.

I know that I can find the Rebuild Sheet icon in the toolbar, but my users dont want that.
They prefer a very visible Button on the websheet.
I tried the Button function, but it does not seem to have a rebuild option in it.
Do you know if it exists.
thanks
Thanks
Micheline

Wim Gielis
MVP
Posts: 2257
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Websheet Refresh Button in WORKSPACE

Post by Wim Gielis » Wed Jun 12, 2019 9:08 pm

Rebuilding the sheet is one of the properties near the bottom of the action button ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

tomok
MVP
Posts: 2630
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Websheet Refresh Button in WORKSPACE

Post by tomok » Wed Jun 12, 2019 10:12 pm

mnasra wrote:
Wed Jun 12, 2019 7:42 pm
Hi Expert,

I have an active Form with a Rebuild Sheet Button.
When I added the websheet in Workspace the Button does not work.
Did you build the Active Form in PAX or Perspectives? If Perspectives, have you run the utility that converts the action button to work in Planning Analytics?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

mnasra
Posts: 93
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Websheet Refresh Button in WORKSPACE

Post by mnasra » Tue Jun 18, 2019 8:35 pm

Oh wow. Thank you all. Yes I built it in Perspectives. And no, I did not even know about the utility. I am looking into it. Thanks again
Thanks
Micheline

Wim Gielis
MVP
Posts: 2257
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Websheet Refresh Button in WORKSPACE

Post by Wim Gielis » Tue Jun 18, 2019 8:45 pm

Can you please update the version information in your profile please, TM1 and possibly also Excel ?
I know for a fact that TM1 9.5.1 was launched June 17, 2010, so that's ages ago ;-) and Worspace was not part of that version ;-)
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

mnasra
Posts: 93
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Websheet Refresh Button in WORKSPACE

Post by mnasra » Tue Jun 18, 2019 9:29 pm

Thank you Wim. I just changed it. But I am a consultant, so I have customers with different versions.
And actually, My problem right now, is on the IBM Cloud BLUE. (formely cloud concierge).
I just ran the utility for the action button.
I also wrote a completely new report with PAX. I cannot make this button work (for a SHEET rebuild).
Also, the add Button in workspace, does not give me the option to rebuild.
I am sure, I am doing something wrong. Because it cannot be my environment, I am on IBM's
Thanks
Micheline

mnasra
Posts: 93
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Websheet Refresh Button in WORKSPACE

Post by mnasra » Tue Jun 18, 2019 9:44 pm

GOT IT. Sorry, I was still trying to use my old button.
I created a new one with PAX and it worked fine.
THANK YOU Very much all
Thanks
Micheline

Post Reply