You are planning to create an Income Statement using Smart View.

To create an Income Statement using Smart View, you should use Ad Hoc Analysis. Ad Hoc Analysis is a Smart View tool that allows users to view and analyze financial data from General Ledger Cloud using Essbase cubes. Users can create reports such as Income Statements or Balance Sheets by selecting dimensions and members from Essbase cubes and retrieving data into Excel worksheets. Users can also perform actions such as drilling down, pivoting, zooming in or out, or expanding or collapsing members