Skip to Content
0
Former Member
May 30, 2011 at 01:44 PM

SAP BEX Calculated Column

579 Views

Hi ,

I would like to thanks to all who helped me in getting my work done for my previous questions.

This time i came up with some new questions ... is there a way to create a calculated column in the SAP BEx query ? I dont have global query edit permissions but i can chage the Local View of the query.

1 )

I have a Original Hire Date and Most Recent Hire Date as two columns in the BEX Query, when i refresh the query it will populate in tow different columns which is usual. But, i would like to combine these two DATE columns (based on some criteria) as one and want to produce as a single DATE columns.

would it be possible... ?

2)

I have two query's in a workbook and the first query will give the employees ID's which i have import in the second query. Is ther any way to import these ID's in to Second query automatically through VBA or some other code ... ?

Thanks in Advance for you kind help.