A Bex Query on the Cloud
In this weblog i would demonstrate how to display the result’ data of a Bex Query on SAP Business Object Explorer in the cloud. What’s SAP Business Object Explorer in the cloud?? SAP Business Object Explorer in the cloud is a SAP Business Object Explorer, available at everyone, where you can visually explore and analyze your Excel spreadsheets and is available at this address: https://create.ondemand.com/explorer.
Here is possible to download an Addin for Microsoft Excel.
After that you have dowloaded and installed the Addin for Microsoft Excel , a new component appear on Microsoft Excel.
At this point, you can send result’s data of a Bex Query to SAP Business Object in the cloud. To do this, you could follow these step’s:
1) execute a Bex Query by BEx Analyzer or by Advanced Analysis for Microsoft Excel (in the image the Bex Query is the Sales Order Material of SAP Business Content):
2) select all table content, push the button “Explorer in the cloud” and the the button “Send Selection”.
Et voilà.. the result’s of a Bex Query are in the cloud of SAP Business Object Explorer:
When you selected “Send Selection” , you could receive this error message :
To avoid it, is necessary set this properties on characteristic infobject’s:
1) always suppress the result value
2) disable the option: Suppress Repetead Key Figure.