Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
fdranguet
Posted - 06/21/2010 : 08:12:17 Hello,
I found a bug on Report Portal last version (build 170) that I was able to reproduce on your server: please take a look at "Multi select with User Filter test" under "My Reports" from admin user. In this one, I set dimension "Store" as a filter, and selected "All Stores". In the meantime, I created a "User filter value" called "FDR_TEST" on this dimension, and set it for this filter. Next, I created a user (fdranguet) and put in its "User filter value" for "FDR_TEST" the following values: [Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA].[OR]. Now, when I open this report with this user, it is showing what I am expecting.
The issue is, when you subscribe on this report for this user, the job will fail because it will treat those user filter values as a single selection from the filter (while you are having two elements). This is resulting in some MDX code with "Where ( [Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA].[OR]..." that is obviously failing. Please take a look under "Shared Schedules", "Manually ran" and you will find one of this failing jobs.
Could you fix this issue in one of your next releases ? Thanks.
Regards, François
1 L A T E S T R E P L I E S (Newest First)
admin
Posted - 06/22/2010 : 10:35:08 Thank you for reporting this problem. It will be fixed in the next build.