gtonkin wrote:TM1 Server 10.2.2
Code: Select all
ViewTitleElementSet(CubeName, ViewName, DimName, Index);
FYI, do not use this command as it can return incorrect results for any dimension which has element security.
It takes as an argument an index to a dimension and it then uses that index to show a specific element. The problem is that for a dimension which is secure a user can run DIMIX/DIMNM and it will return the correct results i.e. same results as Admin even though they may not be able to see those elements. The problem comes in the view when the user looks at the title element which has been set, because it is an index pointer to the dimension based on the ALL subset it shows the nth element based on the ALL subset which that user has privileges to.
Hard to explain without seeing it in action and not sure if it is a newly introduced 10.2.2 bug either.
Please be aware of this quirk if you are thinking of upgrading to 10.2.2
@MODS -> please move to bugs-thank you
Hi George - this has nothing to do with 10.2. It is a standard feature and is not a bug.
Title elements are set by index of a defined list as opposed to by element name. This is a standard watchout - if the order of the members in the list changes or the content of the list changes then the index will of course return a different element name. In the case of element security then the member list will be different for different users, this is "expected behaviour".
Generally in the case of element security this is a good thing as it means that rather than nothing being displayed and the user receiving an error message as would be the case if selection was by name and the user had no access to the selected element then the view will return something (unless maybe the saved index value is now greater then the size of the list.) This is actually quite useful for default cube views where users should always see the 1st element they have access to for example (just make sure when setting up the subset used for the list that everyone will be able to access
something from the list.)
It is something to be aware of though and should be considered EARLY in system development as if dimension structure is changed or default subset of a common dimension used in a lot of views then it can be a lot of (manual) work to go and edit views to make sure the correct element is selected.
It would be great if there was also a way to set title dimensions by element name and not index. But I can understand the way it is the way it is, precisely because of element security.
