I have a worksheet with =SUBNM("dimname", "Default", 1) where users have private default subsets.
the xls template was designed to display a cost centre list applicable to the user security group.
so when the sheet/page is opened, it displays the 1st cost centre from a small list(their own private default subset).
this works fine within excel, but from the web; the public subset is always shown until the subset editor is clicked
is this a bug (v9.4 FP3) or just the way TM1Web was designed.. and if it is, is there a workaround.
Thanks
TM1Web private subset overridden by public
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1Web private subset overridden by public
I can't recall if TM1 Web was always this way of if this functionality was modified to support the requirements of the Contributor front end. (Due to how Contributor Apps are designed and deployed it is necessary for public views and subsets to take prescience over private objects.)
I only have 9.5.1 to test on so I can't confirm if it has always been this way or not, (someone else might be able to test on 9.4 or 9.1). But I don't think there is anything you can do to change this to make it consistent with Perspectives behaviour. If your application relies on private subsets (of the same name) containing different elements then you would need to alter the design to use element security with public subsets to achieve a similar result.
I only have 9.5.1 to test on so I can't confirm if it has always been this way or not, (someone else might be able to test on 9.4 or 9.1). But I don't think there is anything you can do to change this to make it consistent with Perspectives behaviour. If your application relies on private subsets (of the same name) containing different elements then you would need to alter the design to use element security with public subsets to achieve a similar result.