Page 1 of 1
change TM1 websheet property
Posted: Wed Mar 04, 2015 7:35 am
by wang_chris
We don't want title element and its selection to be displayed in websheet, we have set the websheet property in architect as description in user guide, but it seems not work when we view the websheet from TM1web.
Is there anything more to set?
Re: change TM1 websheet property
Posted: Wed Mar 04, 2015 10:39 am
by declanr
Just hide the row or change the subnm formula to be:
I assume by "property" you are referring to the "Read Only" tick box? That has always been a bit flakey in my experience; in 10.1 you will find that locking the cells and then protecting the sheet before loading it up is a simple way of making a sheet read only.
Re: change TM1 websheet property
Posted: Wed Mar 04, 2015 12:00 pm
by wang_chris
If the Dimension element is hidden, when we call TM1 websheet in BI, the element value can not be passed into this websheet.
We don't want these element selection not to be displayed, but still be effective in websheet.
How can we handle it?
Regards,
Chris
Re: change TM1 websheet property
Posted: Wed Mar 04, 2015 1:02 pm
by declanr
Assuming you are using the URL API to open the websheet you can still pass parameters through to Title Elements when the row is hidden.
You can then have a displayed row that has a formula equalling the hidden cell.
Re: change TM1 websheet property
Posted: Wed Mar 04, 2015 1:40 pm
by wang_chris
Unforturnately, we are using BI framework to call TM1 websheet, not URL.