You do not have Read access to the Table object 'Logical Table for max day'.
Error(s) occurred while loading report: DSSSQLEngine: Schema loading error: There is error in report definition. The element shown in the following hierarchy has invalid definition or no longer exists: Report (count thermal). -There is error in report definition. The element shown in the following hierarchy has invalid definition or no longer exists: Report (). -Fact GroupCOM interface error..
This document is defined based on a report named “count thermal”, while a freeform SQL report “max day” is embedded as its report filter. When a non-admin user executes the document in Web, this error occurs.
CAUSE:This error occurs due to No-admin user do not have enough privileges to access to the embedded freeform SQL report.
ACTION:- Give the Non-admin user privilege of “Bypass schema objects security access check”. But it should be cautious due to security consideration.
- Give user view privilege of freeform SQL report described in KB48008, as shown below:
KB48008: "[You do not have Read access to the Table object 'Logical Table for xxx']" error message appears in the DSSErrors.log when non-admin users run a document based on a freeform SQL report in MicroStrategy 9.3.x - This issue also can be resolved by add freeform SQL report “max day” as a document dataset.
