I recently built a report and provided the user with a query. The table contained LedgerDimension field which provides a handy filtering using Main account and financial dimensions. Something like this:
As a developer (having SysAdmin rights) the dimensions were there showing to me but once the report handed for UAT I got a complain that all fields are showing except financial dimensions! Oh, must be a security issue!
After few tests, I found out that by granting Read to the Table that query is based on solved the issue. Could be solved either from Front-end or Back-end