Hierarchy node variables filled in RSROA_VARIABLES_EXIT_BADI do not work in Analysis for excel/olap

[Lynn_vr]

Hi

Please can someone assist me, I have been sitting with this for this urgent requriment and cannot get it to work. What i need it to fill a org unit on the org hierarchy so only from that orgunit and below can be seen. I created the code in the badi RSROA_VARIABLES_EXIT_BADI and did a test in hana studio and it works perfectly. When i pull the query into analysis for excel or olap it does not work - it is looking for a +7000000(orguint) and not the straight 70000000.

Please if anyone can assist I will be so grateful we are running BW4hana with business objects 4.3 sp2

BW (SAP Business Warehouse) 

Kind Regards

Lynn