You are planning to create an Income Statement using Smart View. Which Smart View tool should you use for this?

Smart View's Ad Hoc Analysis feature is the most suitable tool for creating a structured, formatted financial report like an Income Statement. It allows a user to connect directly to the General Ledger balances cube (Essbase) and then interactively design the report layout by selecting dimension members for rows, columns, and the Point of View (POV). Users can pivot, drill down, and apply formatting within Excel to build the statement from the ground up, providing the necessary flexibility for financial reporting.

A. Smart Queries are primarily used for creating and executing queries to retrieve raw data, not for building formatted, multi-dimensional financial statements.
B. Smart Slices are created from existing reports (either ad hoc grids or forms) to be embedded in other Microsoft Office documents; they are not the tool for initial report creation.
D. Query Designer is a tool for building specific queries, often for a predefined data set, and lacks the flexible, multi-dimensional pivoting capabilities of Ad Hoc Analysis.

Oracle Smart View for Office User's Guide, Chapter: Smart View and Essbase, Section: About Ad Hoc Analysis. (Doc ID: E52724-01, Chapter 7). The guide describes ad hoc analysis as the method to "analyze data from Essbase data sources" and "change the data that is displayed and the way it is displayed."