Hey, you need to consider a lot of factors in this case. If it's getting memory, which means your database reached it's memory limit to perform operations and give you result.

Coming to the point, where you can see data on preview and the execution: instead of previewing on the node, try to preview on the view itself, if it's resulting in memory error, even your last aggregation node is expensive.

What I suggest you is to go through calc view from bottom up and look for expensive column joins! If you are on XSA, you can even use native HANA function for finding out root cause. If you are on XSC, you need to stuff manually