I wanted to know if there is a way to hide a property from user view. This is not to stop the user from using the value but they are hidden from the user. I know this sounds odd but let me try to explain.
The two example I can provide is I am setting up a shortcut URL to SSRS and want the user to see the value labels but the the shortcut link will use the code.
PriceList (property user sees) = PriceListA, PriceListB
URL (property of URL string) = http://yourserver/blah/blah/report&PriceList=10,20
In the above the user would see the price list Property (the names) but the shortcut link has the full URL. I dont want them to see the URL as a property, BUT the user has to obtain the property for the URL shortcut.
In QlikView we could create a hidden prefix code such as “_" which any fields which are prefixed with this would be available for use but hidden from users. So in the above the url would be called "_URL”, available but not visible for display.
So this is not a data restriction per se, rather a system type property I don’t want the end user to see.
NOTE: I cannot use the https://mywebsite.com/CustomerInquiry?CustomerID=%% approach listed in the external sites shortcut link documentation due to complexities in the SSRS report parameters. The URL constructed in SQL works but I simply don’t want the users to see it directly, only indirect via the shortcut URL.
Another example which @StuartH provided is custom sort orders where you want to assign a numeric value to a property/dimension so it is sorted by a custom numeric order (hidden) and the text is displayed, think of an ordered checklist which you would not sort alphabetically but it would be based on an ordinal position. So the sort would be:
1 - Get out of bed
2- Brush teeth
3- Put on clothes
Currently in Phocas the order would be:
Get out of bed
Put on clothes
Hope this makes sense. Anybody discovered a way of performing this?