Access is denied to 'zHomepage_SalesGrossMargin' query

Hi,
I copied this standard “zHomepage_SalesGrossMargin’ query” and renamed it as per my requirement. Created a new ssrs report with this copied query and published it.
When a user is trying to download this SSRS report, its throwing the below error in the system montior. But its accessible to users who had only “Security Manager” access. why is that so? I cannot give “Security Manager” access to everyone.

image

Thanks
Subha