I have an OLAP report with user filters of
[AccountManager].[Account Manager].&[126],
[AccountManager].[Account Manager].&[259]
and
[Branch].[All Branch].[NORTH SHORE]
The user belongs to a role but the role has no filters.
I run a report by Account Manager, branch, year and revenue. It contains the two account managers correctly but includes an 'All' member whose sales are equal to all the account managers, not the two which are in the filter.
eg
+All 687,060
AccountMgr1 280,117
AccountMgr2 8,994
This only happens when the filter contains more than one value.
Has any one any ideas please
|
Report Portal
Report filters not working correctly
Posted - 09/03/2015 : 21:07:36
