Executing a Smart Query Execute saved Smart Queries in the Manage and Execute Queries dialog box. To execute a Smart Query: In Excel, connect to an Oracle Essbase data source. From the Essbase ribbon, select Manage and Execute Queries to display the Manage and Execute Queries dialog box. Select a Smart Query from the list in the left frame and click Execute.The dialog box closes automatically and the Smart Query results appear on the sheet.