Hi everyone,

we want to restrict access to users for a dashboard. Therefore we match the user_name() to an uploaded excel.

But since some users should see whole regions and others just single plants we want to adapt the dimension based on the excel input.

To make it more understandable:

FILTER VBAP.WERKS =

(CASE WHEN EXCEL.EMAIL= USER_NAME() THEN EXCEL.WERKS)

This is working fine. However making the "VBAP.WERKS-part variable doesn't work yet.

(CASE WHEN EXCEL.EMAIL = USER_NAME ( ) AND ISNULL(EXCEL.WERKS) = 0 THEN EXCEL.WERKS' ELSE 'EXCEL.REGION' END)

So the idea is that this also leads to: FILTER VBAP.WERKS = EXCEL.WERKS

Does anyone have an idea how I have to adapt the part that chooses the dimension?

Best regards

Aram