Deactive a hierarchy in query execution time

[Former Member]

Hello all

I have a requirement a little bit peculiar , so I am going to try to explain it as clear as possible.

We are using infoObject 0PRCA_ID, which have different hierarchies associated (depending source system and company code). The majority of the users have access to their own company code data which means that 0PRCA_ID hierarchy is well defined; however there are other users that have access to multi-company data: on this case we don´t want to display 0PRCA_ID in a hierarchical way, we would like to deactivate hierarchy, and we are trying to do it in query execution time.

Does anybody know if there is a way to do it?

Thanks in advance.

Regards,

[Former Member]

Hello all!!

First of all thank you for your responses, but what I exactly want to do is deactivate this hierarchy in execution time, I mean, using Abap code in the bw exit.

Is this possible??

Thanks in advance

Regards.

[former_member207028]

Hi Maria,

infoobject 0PRCA_ID have active hierarchy in query, and once query is executed you can switch off hierarchy, by selecting the properties of infoobject 0PRCA_ID, both in Bex Analyzer and in BEx Web. user can do this after executing the report.

Best Regards.

[hai_murali_here]

Hi,

You want to deactive the Hierarchy during the Execution time,this can be achieved through BEx Analyzer,when you execute the query.

Open the Query->Go to Characteristic Properties of infoObject 0PRCA_ID->Hierarchy tab->Select the Hierarchy in the dropdown and check "Deactivate the Hierarchy" checkbox->Click OK.

Rgds,

Murali