cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Query generated code hack

Former Member
0 Kudos
92

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Ok got it!!

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