When trying to select a UFV within Report Options / Dimensions a defined UFV is not always listed. This happens in both new and existing Reports. There are values defined at the Role level. There are two groups of Roles into which all Users are categorized. Group 1 specifies which Branch a role belongs to. (e.g. Tampa) Group 2 specifies which level of authority a role belongs to. (e.g. Branch Manager) Members of Role Group 1 all have UFV values specified. Members of Role Group 2 have no values specified as these roles are only used to control access to Report Folders. Does having two groups of Roles cause a clash of interest in the UFV mechanism?
What do you mean by “Dimensions a defined UFV is not always listed”? Is the filter for the dimension hidden? Can you please try to reproduce the problem on the demo server (http://www.reportportal.us)?
You should be able to specify the User Filter Value on multiple Roles because you can specify the priority.
When selecting the Dimensions tab in the ReportOptions dialog there is a drop down list to choose a UFV but sometimes the only entry in the list is "none"
The drop down list is populated with User Filters that have OLAP filter type and are not hidden. Here is the query used:
SELECT FilterId, FilterName, ServerName, CatalogName, CubeName FROM FilterDef WHERE FilterType = 'OLAP' AND IsHidden = 0 AND (IsNull(ServerName,'') = '' OR ServerName = 'Server1') AND (IsNull(CatalogName,'') = '' OR CatalogName = 'Foodmart 2000') AND (IsNull(CubeName,'') = '' OR CubeName = 'Sales')
The problem was that the ServerName was listed as Local Analysis Server. Once I changed the entry to the actual name of the server the problem disappeared.
Report Portal
User Filter Value not offered for a Report
Posted - 05/16/2011 : 14:47:12
