Hi I have TM1 Perspective SpreadSheet Browser (ISB) template which was working perfect. Everytime i recalc the whole view is re-sync (including new elements)...so everything was fine. Now today when I open the template the buttons are all like some shapes which can be selected and when clicked on it wont launch subset browser...it does nothing.
Anyone faced this issue? can tell me why this might happen? I have enabled macro but still same issue.
thanks for help.
TM1 Perspective SpreadSheet Browser (ISB) Objects Issue. Please advice.
-
- Posts: 32
- Joined: Mon Jul 20, 2015 7:19 am
- OLAP Product: Microsoft
- Version: 10.2
- Excel Version: OFFICE365
TM1 Perspective SpreadSheet Browser (ISB) Objects Issue. Please advice.
TM1.Prespectives.Win7.Office365,Excel2016,Excel2010
-
- Community Contributor
- Posts: 219
- Joined: Mon Jul 23, 2012 8:31 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: TM1 Perspective SpreadSheet Browser (ISB) Objects Issue. Please advice.
I get the same issue, mostly get that when I change the "View" it had initially to something else and then save the file.
My temporary fix was to use a Default "View" that my users have to change each time they open the template.
Not the best solution but we only use ISB to pull a View that can be used to extract a more elaborate "Drill to Transactions" than perspectives can do.
My temporary fix was to use a Default "View" that my users have to change each time they open the template.
Not the best solution but we only use ISB to pull a View that can be used to extract a more elaborate "Drill to Transactions" than perspectives can do.
-
- Posts: 32
- Joined: Mon Jul 20, 2015 7:19 am
- OLAP Product: Microsoft
- Version: 10.2
- Excel Version: OFFICE365
Re: TM1 Perspective SpreadSheet Browser (ISB) Objects Issue. Please advice.
You're right RJ. I tried the updating the view from Viewer and I am able to replicate the issue. thank for your help.
Also please advice. Do I need to have dynamic ActiveForm have lastest heirarchy sync/updated in my Excel report?
Also please advice. Do I need to have dynamic ActiveForm have lastest heirarchy sync/updated in my Excel report?
TM1.Prespectives.Win7.Office365,Excel2016,Excel2010