I guess by "QView" you mean a Cube View?
The reasons for differences between raw SQL values and Cube View displayed values can be many - formatting , DynamicCalc intersections, ConditionalInput rules, access rules...
I think your problem really is this: "a QView wouldn't display everything according to the required permissions, which in this case [you think it] doesn't apply" You're trying to bypass OneStream security, instead of working with it. The right way to go about this is figuring out why that is, and address it the right way. If you can't touch anything in that cube setup, for example, you could copy the necessary data to a separate cube and apply different security there.
I created the cube view and yes, I encountered that security issue, so how could I go about displaying the information to someone who couldn’t see it?
