change TM1 websheet property

[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?

[declanr]

Just hide the row or change the subnm formula to be:

Code: Select all

=""&SUBNM(...)

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.

[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

[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.

[wang_chris]

Unforturnately, we are using BI framework to call TM1 websheet, not URL.