2895224 - Error When Accessing a Dashboard: 'XYZ' Filter Cannot Be Applied As You Are Not Authorized For The Lead Report

When accessing a dashboard, you can see 'XYZ Filter Cannot Be Applied As You Are Not Authorized For The Lead Report' error message.

SAP Cloud for Customer

Case 1:

1. Go to Business Analytics work center.
2. Go to Design Dashboards work center view.
3. Search for a dashboard.
4. Open it.
5. You can see the error message.

Case 2:

1. Go to Analysis work center.
2. Go to Dashboard work center view.
3. Open the specific dashboard.
4. You can see the error message.

Error Message: XYZ Filter Cannot Be Applied As You Are Not Authorized For The Lead Report

Case 1:

It occurs when the characteristic used as a filter in the dashboard was added to the report via 'Add Fields' instead of via 'Report Wizard'. You can check it following these steps:

1. Go to Business Analytics work center.
2. Go to Design Reports work center view.
3. Open the report used in the dashboard.
4. Open and run it.
5. Go to View > Add Fields. 
6. You can see those characteristics were added via Add Fields.

Please note that a field was added via 'Report Wizard', it will be grayed out in the 'Add Fields'. If the field was not added via 'Report Wizard' it will not be grayed out and you can edit it via 'Add Fields'.

Case 2:

It occurs when an end user has personalized the report view used in dashboard and enabled the hierarchy for one of the field which was added via Add Fields (rather than adding the field via report wizard).

In order to adjust the report and avoid such cases, you can follow these steps:

Case 1:

1. Go to Business Analytics work center.
2. Go to Design Reports work center view.
3. Open the report used in the dashboard.
4. Click to Edit.
5. Go to Step 4.
6. Search the field used a filter.
7. Change from 'No Selection' to 'Using Variable'.
8. Save it.

Case 2:

1. Go to Analysis work center.
2. Go to Reports work center view.
3. Search for the report with the view which has been used in dashboard (or the report where you have done the personalization).
4. Open the report.
5. Go to View tab and click on Add Fields.
6. Search for field where hierarchy has been enabled.
7. Check if hierarchy enabled field was added via Report Wizard (by Admin/Key User).
8. If not, then disable the hierarchy (uncheck the box for hierarchy) for that field.
9. Save the report view (overwrite it, do not save a new view).

Then, the dashboard should not display those messages warning messages.

filter cannot be applied as you are not authorized for the lead report, filter, dashboard, warning message, characteristic filter cannot be applied, hierarchy, end user, personalize , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , LOD-CRM-ANA-DAS , Interactive Dashboard , How To

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions