Websheet Refresh Button in WORKSPACE

Post Reply
mnasra
Posts: 136
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 »

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: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Websheet Refresh Button in WORKSPACE

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
tomok
MVP
Posts: 2831
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 »

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: 136
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 »

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: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Websheet Refresh Button in WORKSPACE

Post by Wim Gielis »

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

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mnasra
Posts: 136
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 »

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: 136
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 »

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