What is the use of 'Convert to Formula' in BEx Report?

[Former Member]

Helo BI Gurus,

After refreshing the query in BI, when I right click on the query report, I am getting an option 'Convert to Formula'. Can you please tell me the use of this option, and how we can use this in our report and what the result we will be getting?

[Former Member]

Hi Mathew,

The Convert to Formula in Excel Allows you to Convert you Embedded Bex Query into API Calls. This enables you to Better Format the Excel Output by allowing you to move your Cells Around.

This helps because when you refresh you Query all the Changes you make will be maintained.

[More Info on Working with Formula|http://help.sap.com/saphelp_nw70/helpdata/EN/d3/015369f54f4a0ca19b28c1b45acf00/content.htm]

Hope this Helps

Datta.