TM1Web private subset overridden by public

Post Reply
User avatar
yyi
Community Contributor
Posts: 122
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

TM1Web private subset overridden by public

Post by yyi »

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
chevron7.gif
chevron7.gif (879 Bytes) Viewed 2184 times
is this a bug (v9.4 FP3) or just the way TM1Web was designed.. and if it is, is there a workaround.


Thanks
Yeon
lotsaram
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

Post by lotsaram »

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.
Post Reply