Load BEx Query with two structures to DSO

[former_member375076]

Hello,

I need some help. I am trying to perform some calculations in BW on roll up points in a hierarchy. So an example Roll Up on account + Rollup up on Account = Account (Leaf). There are a dozen formulas like this.

The best way i could think to do this is build a bex query and write the results to a DSO, btu I can't do this with a query with 2 structures (one for measures and one for accounts). Any ideas on how to achieve this?

THANK YOU!!

[former_member231709]

You can try to use FM RRW3_GET_QUERY_VIEW_DATA or Application Process Designer (APD): https://wiki.scn.sap.com/wiki/display/BI/Function%20module%20RRW3_GET_QUERY_VIEW_DATA https://blogs.sap.com/2011/08/27/capturing-data-from-bex-query-output-and-storing-in-bibw-data-targe...

[former_member375076]

This function module works great, but where can I find the view ID?