Using the View Designer in Smart View, you can create ad hoc views based on an Oracle BI EE subject area. Views created in Smart View can be saved to the Oracle Business Intelligence catalog and edited in either Smart View or BI Answers.
View Designer is available in Microsoft Excel, Word, and PowerPoint.