Bex Query generated code hack

[Former Member]

Hi SDN,

Is it possible to manipulate characteristic values based on the key figure values in BEX Query output. Is that hack possible to control the query generated code at all?..

per say i have query out put like this (in a very simplified version)

Material customer Quantity customer_pcount

M1 C1 100 1

M2 C2 150 0

when customer_pcount = 0 related customer value need to be blank.

Out put should look like this:

Material customer Quantity customer_pcount

M1 C1 100 1

M2 150 0

thanks

[Former Member]

You could do this within BEx Analyzer usign VBA macros or in 3x web using table API, not possible to change the generated code.

[Former Member]

Hi deepu,

Thanks for the reply :

If I have VBA code in Bex will it reflect the same changes when query published in portal??

[Former Member]

VBA code will work only if you run the query as the Bex analyzer workbook.

If you publish the workbook to Portal it will work, if publish the query it will not work.

[Former Member]

Ok got it!!

Can please help me with quick and dirty code for the scenario i mentioned in the other post