User not able to view some columns in a report

[Kajal Kanojia]

The user is not able to view few columns in the report and those columns are the Variables of a Catalog.

The Catalog is not having any visibility criteria and the User is also having report_user role.

Can someone please help why is the user not able to see those columns 

[Jaspal Singh]

Hi Kajal,

You might need to review the ACL of type Read for sc_item_option_mtom table once.

[Aman Kumar S]

If it is catalog variable, it could be an ACL issue for the variable table.

Can you check read acl for sc_item_option_mtom and sc_item_option tables.

Try to add role of the user to read acl and verify the report.

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[Aman Kumar S]

Hey @Kajal Kanojia 

Didn't hear back on this.

Is your issue resolved? If yes, feel free to mark helpful/correct, so it will be helpful for others looking for similar query.

[AysenurU]

Hi Aman

Creating new read ACL for  sc_item_option_mtom and sc_item_option tables worked for me.

Thank you