OK, is my title long enough? I'm not sure where to really post this. We built a cube and have dimensional security enabled, enabled Kerberos and windows authentication, built a few reports and published them in both SSRS & PPS content on a dashboard. My question is when a user views a report, if they do not have access to the measure on the report it gives a funky 'infinity axis' type error. Some reports have a combination of both an unsecure metric and a secure metric, these also error out. I would like to know the best way to handle these errors so that the user gets a decent error message, or at a minimum can see the reports with a combination of secure and unsecure metrics... We are running Sharepoint 2010, and all 2008R2 products. Thanks! k2

I guess simply stated how do I HIDE the entire chart/report if the report resolves to an error? I tried using the "nodatamessage" however problem here is that the dataset does return data...i need to evaluate the chart at the report level, i would think... thanks, k2

First of all you need to figure out why you are getting infinite in cube measure, if user dose not have permission than you should get blank or NULL. Not #Error or Infinite. Check your expression in your cube and try to make it NULL if any divide by zero is happening. Once you get NULL, you can modify your reporting “NoDataMessage” to check for if SUM of measure value for whole data set is blank or NULL or IsNothing (if user don’t have access than it will be NULL I suppose). In this way you display the “NODataMessage”. Let us know if you need anything else.Gaurav Gupta http://sqlservermsbiblog.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

I thought I tried this and it did not work, I will try again. Basically there are 2 measures, revenue and margin. A user might not have access to Margin because it contains a persons salary rate. If the margin is restricted when a person runs a report, SSRS can't plot the series (on a dual axis graph) and it gives an axis infinite error.

Forgive me here, but how do I make it null? IIF(isnothing(field!A),system.dbnull,field!A) and I get a message saying I can't use system.dbnull in an expression.

I used this link and about 1/3 down the page, I used the example of adding a rectangle with an embedded text box in order to evaluate a single metric: http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx#alternating This is not a very eloquent solution in my opinion. OBIEE has a report level evaluation, with one simple step. Am I missing something in SSRS or can we do this at the actual REPORT level? thanks,

I thought I tried this and it did not work, I will try again. Basically there are 2 measures, revenue and margin. A user might not have access to Margin because it contains a persons salary rate. If the margin is restricted when a person runs a report, SSRS can't plot the series (on a dual axis graph) and it gives an axis infinite error. Hi Slowgawd, You could return all the datafields even if margin, what you need to do is to hide margin column based on UserID using IIF function. For more information about IIF function, please see: http://msdn.microsoft.com/en-us/library/ms157328.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.