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:

missing financial dimensions on query filter

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment