User's Guide Smart Query Executing a Smart Query Executing a Smart Query Execute saved Smart Queries in the Manage and Execute Queries dialog box. To execute a Smart Q\query: In Excel, connect to an Oracle Essbase or Oracle Analytics Cloud - 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.