This has been needed for some time. The functionality is good, but usability needs improvement.
1) Move the list to the ribbon area and off the sheet as it limits working space (takes 4 columns on my monitor). The model to follow should be the very well received In2Hyperion (old Essbase Excel Add-In extension).
2) Quick Options should grey out and disabled based on the connected source type.
You might want to raise an SR so that support can validate your requirement